Oh, YES, if you pay for leased production space and/or you know your db is not growing, there...

That had been verified. The rollback was not going anywhere for hours. Some contractor issued "DROP ASSEMBLY [SqlClassLibrary]".... Instead waiting for hours, we have to get it back even from...

Microsoft SQL Server 2005 - 9.00.4266.00 (X64) Oct 7 2009 17:38:17

Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack...

Refresh in layman's language means make that database the same....

It is true, however that Microsoft guy did not know if you use multiples of binary number, you save space allocation. When do you have a device name...

GRussell31 (10/1/2010)

---

Hi jswong05,

My understanding is that when a backup is performed it will truncate the transaction logs (and I couldn't find a way to stop this), as trancating the logs...

GRussell31 (7/16/2010)

---

We have a slightly more complicated scenario...

Our production database is backed up up using a 3rd party system which does not appear in the msdb tables, on top of...

Madhu R (3/23/2010)

---

Hi,

Thanks for your script.

I run the script. But its didn't turned out any index need to be defrag or whatever.. !! First its told me the...

The point is to emphasize again, what you lose and don't lose on each method (the data that wasn't taken care of...

There is no magic, it is suggested you fool the engine by renaming mdf file or use backup file. You lost what is in the transaction log that hasn't been...

The principle is the same, the implementation depends on the nature of your business.

If quick fix is applicable and acceptable without incurring much cost, you can quick-fix it everyday.

By 80-20...

If you work for the bank, you wait for import duplicates then delete, you are dead already.

If you work for car-wash, it is OK.

Row_number() function needs order by.

Never use...

Follow this MS article to tune your system:

http://technet.microsoft.com/en-us/library/cc966540.aspx#EGAA

The Microsoft publication is great. But after I set SPN for the service account, I went to AD (based on page 6, Figure 2), the registered SPN entry is not...

Harold Buckner (12/11/2008)

---

Bradley Deem (12/11/2008)

I have the EXACT same problem with Kerberos. Resulting in the NT AUTHORITY\ANONYMOUS LOGON. It does work though, because I'm able to connect from...