Most efficient would be the 3-byte date data type.

Second would be an integer storing the number of days since January 1, 1900 (use DATEDIFF(d, 0, <input_date_value>) to calculate the value,...

You have lots of time and the database files are small. This can be easy:

1. Detach each database. This will complete all active transactions and shut down each database in...

morleyf (4/19/2016)

---

Is mixing the DMZ and internal databases on a single cluster a bad idea?

... Since this Instance is servicing public facing applications in the DMZ, is it safe to...

Ray K (3/30/2016)

---

I came up with an abstract. Let me know what you people think.

Groupthink is a phenomenon that is highly destructive -- and all too common in group...

szejiekoh (3/22/2016)

---

Hi all,

Specifies the TCP/IP authentication requirements for connections for this endpoint.

Does the "for" actually means "to" ?

-- means that client connections to this endpoint must be authenticated with...

If the source database is live in production, and the Database Master Key (DMK) has been encrypted by the instance's Service Master Key (SMK), then you can create any number...

I would start by looking at the following things:

> <frame procname="" line="89" stmtstart="9704" stmtend="18556" sqlhandle="0x03001200f252954d9248480120a400000100000000000000" />

This 9,000-character-long call looks like it's part of a much-larger batch. Examine that for locks...

Check the Windows logs on the server where the errors were thrown, because it looks like you lost the transaction log file, or access to it. My gut says you...

> This database is in full recovery mode, but the client appears to only be attempting full nightly backups.

> I am hesitant to perform any further action until I understand...

Is the following an accurate rewrite of your requirement?

"For each ID, select the row with the lowest prim value"

If so, you're looking at a much simpler query, like:

WITH Names AS...

That's a meaningless alert, in my opinion. Unless it has some description documented elsewhere,...

Is there a Wait Type listed? What's the full message?

A "waiting" thread is simply one that isn't doing anything. For example, the lazywriter thread is usually waiting for something...

What if you read the page with the error:

DBCC TRACEON(3604);

DBCC...

Here's a link to download Microsoft's guide for licensing virtualized environments:

http://download.microsoft.com/download/3/D/4/3D42BDC2-6725-4B29-B75A-A5B04179958B/MicrosoftServerVirtualization_LicenseMobility_VLBrief.pdf

There's a specific section for core-based licensing SQL Server on VMs.

-Eddie

The syntax error can be fixed by adding a table alias to the first derived table (shown beloaw as [PivotSource]):

SELECT group_1Digit, group_2Digit, group_3Digit, chart_code, desc_text,

AA, CL, ED, FB,...