From http://msdn.microsoft.com/en-us/library/bb500469(v=sql.120).aspx

"SQL Server 2014 is available in 32-bit and 64-bit edition."

Seems clear 🙂

Cheers!

You can see some basic information for the processes responsible for the growth of TempDB by querying the default trace. The following query will show the SPID, Login, Host Name...

The nice thing about this is that if you have created the logins with the same name and SID on the secondary server using something like sp_help_revlogin, then if you...

Also, if you just want to see that it is past 9 AM, you could alternatively use the following to avoid CASTing or CONVERTing:

DATEPART(hh,GETDATE()) >= 9

Cheers!

P.S. I apologize if anyone...

Ok, this is not all that pretty, but it at least returns the right values. I'm sure there's a more efficient way of acquiring them, though. It creates a temporary...

Single quotes have to be escaped, which is done by immediately following the single quote you are using as the character in string with another single quote.

For example, if...

You can also check the default trace to get some (albeit limited) information. For autogrowth events, it records the login and application names, which is sometimes helpful. Especially if the...