What is the difference between a stored procedure and a view?
I am confused about a few points: What is the difference between a stored procedure and a view? When should I use stored … Read more
sql-server-2005
Measure the time it takes to execute a t-sql query
I have two t-sql queries using SqlServer 2005. How can I measure how long it takes for each one to run? Using my … Read more
Difference between database and schema
What’s the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. If a Schema … Read more
What good are SQL Server schemas?
I’m no beginner to using SQL databases, and in particular SQL Server. However, I’ve been primarily a SQL 2000 guy and I’ve always … Read more
How do I check if a SQL Server text column is empty?
I am using SQL Server 2005. I have a table with a text column and I have many rows in the table where … Read more
nvarchar(max) vs NText
What are the advantages and disadvantages of using the nvarchar(max) vs. NText data types in SQL Server? I don’t need backward compatibility, so … Read more
How to check which locks are held on a table
How can we check which database locks are applied on which rows against a query batch? Any tool that highlights table row level … Read more
SQL Server Restore Error – Access is Denied
I created a database on my local machine and then did a backup called tables.bak of table DataLabTables. I moved that backup to … Read more
Sql Server string to date conversion
I want to convert a string like this: ’10/15/2008 10:06:32 PM’ into the equivalent DATETIME value in Sql Server. In Oracle, I would … Read more
How important is the order of columns in indexes?
I’ve heard that you should put columns that will be the most selective at the beginning of the index declaration. Example: CREATE NONCLUSTERED … Read more