All this "never use public WIFI" and "never work in public" might be viable when you have a job that requires you to show up in an office from 9-5....

Piling on with Gail.

Yes....

With modern SAN "drives" actually consisting of some number of shared drives, the whole idea of splitting your storage between data and logs gets kind of weird. For most systems,...

It might be part of the white paper that's available here[/url]. I'm just not sure.

OK. Fair enough. Let's try this one. It might also be found somewhere in here... maybe.

You could try searching sys.dm_exec_query_stats in combination with sys.dm_exec_sql_text to find DELETE/TRUNCATE statements. It will tell you when the last execution time was, if the query is still in cache....

You can force the literal string to be NVARCHAR by using the N'Somestring' syntax. Try that with the same code.

The solution posted by Cadavre looks very complete.

One possible change, when looking at the situation where there are fewer columns, in the SELECT clause, I'd probably use COALESCE instead of...

I believe it's part of this report.

That book is absolutely the place to start.

Performance monitor is one of the tools you'll use to capture metrics. Those metrics are listed in the book. You're also going to...

It would be very helpful to know the error.

You can attach an image by scrolling down. There's a section below called Attachments.

Company I worked for did regular searches of the internet for the use of their name. One hit came back on Ebay. A stolen laptop was being advertised for sale...

ScottPletcher (4/13/2015)

Yeah, a couple of hundred rows with no overlap is not much of a test bed. But the plan still shows what I expected: the UNION-only queries concat...

It made me curious, so I put this together real quick:

SELECT a.City,

a.PostalCode

FROM Person.Address AS a

WHERE a.City...

And if you are getting multiple results, instead of DISTINCT which is an aggregation command, use TOP 1 with an ORDER BY of some sort. That's much more likely to...