First, the query costs are not a very reliable measure of performance. Second, increased percentage of a reduced cost can be deceptive, in those cases where the costs end...

I prefer logging data with the UTC date and time. That way, servers in different time zones don't mess up their date/time sequence. Let the UI do the...

UPDATE/DELETE FROM work in all versions of SQL Server that I've worked with, including SQL 2000, 2005, 2008, and 2012. MS isn't planning on removing them. If they...

I always find it interesting how many incorrect answers he has on that list. Even ones...

djackson 22568 (8/27/2012)

---

Companies used to have/show loyalty to employees. As a result, employees were loyal in return. For a very long time companies have thrown loyalty out the...

I have to admit I don't know enough about genetic sequencing to even be aware there's a relationship between...

Same as any other table.

Alternatively, you can set a variable to a statement and then execute it.

declare @Cmd varchar(1000);

select @Cmd =

case

when X = Y then 'sql statement 1'

else 'sql statement...

If you create a globabl temporary table, one that starts with ## instead of just #, and you have a stored procedure that creates that table, then if the procedure...

Are you trying to edit data in Management Studio? Or some other application?

If Management Studio, right-click the table and choose Edit Top 200 Rows. You can view the...

Will sp2 ever be run while the table already exists? As in, while another copy of sp2 is running, or sp3 is running, or any other data is accessing...

Here's some of what I found on it: http://www.sqlservercentral.com/articles/T-SQL/92461/

The discussion (short), has a little information beyond what's in the article.

TVCs simplify a number of things.

Before, you had to do one of these things:

insert into dbo.MyTable (Col1, Col2)

values (1, 2);

insert into dbo.MyTable (Col1, Col2)

values (2, 2);

insert into dbo.MyTable (Col1, Col2)

values...

I'd add one more category to that: Prevent.

I spend a significant amount of my time making it so I won't have to fix things in the future.

I don't want to post interview questions and answers on a public forum, because they'll be mis-used by someone. Don't mean you, but these forums are public (effectively).

But, if...