Craig Farrell (4/19/2011)

---

I recently approached my current HR department about blogging. There is an official policy: Mention you work for us, here's your pink slip. It's primarily so...

First, backing up to the network is not recommended. You usually want to back up locally and then copy to the network.

Second, permissions on a drive/folder is a Windows function,...

Apologies, I think this is it: http://www.red-gate.com/products/sql-development/sql-source-control/assets/video/2011-03-29%2016.02%20SQL%20Source%20Control%20Webinar%207%20_%20Continuous%20integration%20for%20end_to_end%20database%20development.wmv

Use Performance Monitor/ System Monitor, set up a trace that counts the number of users. For DML, you can get batch requests, which is likely close, but depending on the...

Part of your restore process will have to add the users back to the database.

Note when you start in single user mode and log into the SQL Server instance, you need to use a Windows Administrator account and you need a single connection application....

These are old views, for compatibility purposes. Don't use them.

sysusers has been superseded by sys.database_principals (http://msdn.microsoft.com/en-us/library/ms187328.aspx)

syslogins has been superseded by sys.server_principals (http://msdn.microsoft.com/en-us/library/ms188786.aspx) and sys.sql_logins (http://msdn.microsoft.com/en-us/library/ms174355.aspx)

Logins exist at a server instance...

your code would have to

a) know which value was deleted

b) use something like this:

set identity_insert tb_bill on

insert tb_bill (bill_no, Product_code, Pro_desc) select 3, 'ABC', 'Third product'

set identity_insert tb_bill off

If...

It's not this simple. The more I dig into things, the less I think I understand on memory pressure and the many ways to detect it.

First, if total (what you...

Johan is correct, you don't want a function on the column value or you don't use indexes and must scan the table.

For the time, people often do this:

where mydatevalue >=...

Snow

Still coming down in CO, this after I was out running in a t-shirt yesterday

Part of the problem is the <>, which can make you scan the entire table. Plus this can be a large commit, lots of log space required, and more. Typically...

Craig Farrell (4/13/2011)

---

Steve Jones - SSC Editor (4/13/2011)

---

At one point we had a page peel there that opened and covered up the entire screen. I think it was from Quest,...

NTBackup should work, though you need to test. If you haven't restored to another machine, you are potentially not doing your due diligence. If you cannot restore those backups when...

People like to think, so if you can make them apply knowledge without memorizing some answer, it's a good question. Hard to do well, and going off forum posts is...