I've used Measureup before and certainly liked them. Unfortunately they only have exams for the 70-461 & 70-462 so far. I've also checked Transcender and they only have...

Nice job introducing SQLCMD. I spent several hours this weekend trying to write up an intro to SQLCMD myself. You did a much better job than I was...

You can use the object property isMSShipped to help you find user created objects.

SELECT *

FROM sys.objects

WHERE objectproperty(object_id, 'ismsshipped')=0

Sean Lange (3/27/2013)

---

churlbut (3/27/2013)

---

Seems like this article is like old news, not only do I see this mentioned quite often in forums when I have time to check questions, but...

Sean Lange (3/27/2013)

---

Lowell (3/27/2013)

---

OK i now see that SQLFiddle is for MySQL, not SQL Server;

i guess it is some kind of front end tester, where you can build a temporary...

This worked on all of the instances I tried it on.

declare @value varchar(max)

EXEC master..xp_regread

@rootkey = 'HKEY_LOCAL_MACHINE',

@key = 'SOFTWARE\Microsoft\Microsoft SQL Server',

@value_name = 'InstalledInstances',

@value = @value OUTPUT

It...

Could you use xp_regread or something similar?

SELECT *

FROM @Table T

WHERE PID IN (SELECT PID FROM @table

GROUP BY PID

HAVING COUNT(PID) > 1

AND COUNT(DISTINCT JID) > 1)

This won't really help fix your problem, but my guess (and it's nothing more than an educated guess) is that when you pass in parameters sp_executesql automatically adds code to...

You know I was about to reply with a query to parse the string out but then noticed this in Sean's signature.

Need to split a string? Try Jeff Moden's splitter[/url].

I...

CREATE TRIGGER Triggername

ON TableName AFTER INSERT

IF EXISTS (SELECT 1 FROM Inserted WHERE Column IS NOT NULL)

-- Inserted view only exists inside of triggers.

BEGIN

--- Write code here

END

CREATE TRIGGER...

You say this column is used in the clustered index. Is it the only column in the clustered index or are there others? If so is the identity...

Just remember that COLLATE only works on character columns.

I would still double check that your servers & databases have the same collation across dev/test/prod. Otherwise you are...

I would make sure that your production collations are the same as your test ones. IE run the same test, dumping the top 0 into a table and running...

You can read quite a bit about collation in BOL but basically your result sets from the two queries have at least one column with a different collation. In...