sql-server Archives - Page 6 of 16

What are the main performance differences between varchar and nvarchar SQL Server data types?

I’m working on a database for a small web app at my school using SQL Server 2005. I see a couple of schools ...

May 23, 2022
0 Comments

How do I flush the PRINT buffer in TSQL?

I have a very long-running stored procedure in SQL Server 2005 that I’m trying to debug, and I’m using the ‘print’ command to ...

May 23, 2022
0 Comments

SQL Server query to find all permissions/access for all users in a database

I would like to write a query on a sql 2008 that will report all the users that have access to a specific ...

May 22, 2022
0 Comments

Exit single-user mode

Currently, my database is in Single User mode. When I try to expand me database, I get an error: The database ‘my_db’ is ...

May 22, 2022
0 Comments

Why use a READ UNCOMMITTED isolation level?

In plain English, what are the disadvantages and advantages of using SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in a query for .NET applications ...

May 22, 2022
0 Comments

How to write a foreach in SQL Server?

I am trying to achieve something along the lines of a for-each, where I would like to take the Ids of a returned ...

May 22, 2022
0 Comments

How to drop all tables in a SQL Server database?

I’m trying to write a script that will completely empty a SQL Server database. This is what I have so far: USE...

May 22, 2022
0 Comments

When should I use semicolons in SQL Server?

While checking some code on the web and scripts generated by SQL Server Management Studio I have noticed that some statements are ended ...

May 22, 2022
0 Comments

SQL Server Management Studio, how to get execution time down to milliseconds

When I submit a batch (e.g., perform a query) in SSMS, I see the time it took to execute in the status bar. ...

May 22, 2022
0 Comments

Add IIS 7 AppPool Identities as SQL Server Logons

I’m running an IIS 7 Website with an AppPool of Integrated Pipeline Mode. The AppPools does NOT run under NetworkService, etc.. identity (by ...

May 22, 2022
0 Comments