and to the original concern about what to do if more rows came into the mix, i would try something along these lines;

Create table #Mytemp

(Id int ,

value nvarchar(100),

name varchar(50))

insert into...

yes, i know. just wanted to throw out a tally table solution too.

use a tally table.

SELECT TOP 11000

IDENTITY(INT,1,1) AS N

INTO #Tally

FROM Master.dbo.SysColumns sc1,

Master.dbo.SysColumns...

I love the idea of the central monitoring server using linked servers....I use one too. Makes my life so easy.

I use a similar process but its a little less...

SQLQuest29

that is prety neat script. i am adding that to my tool box.

note to other users - send result to text - (CTRL +t)

thanks!

check the file system permissions on the folders where the system databases were installed to verify that the local windows group and or user that runs the agent has the...

if the PROD backups live on the the prod server and the test server is reading that file over the network, then YES. prod will be impacted by disk reads...

TravisDBA (3/4/2013)

---

Geoff,

Please be Be very careful about suggesting or even implying that people should do this on productiohn SQL Servers. i work for the government and the auditors are...

BenWard (3/4/2013)

---

Very useful article, but I can't help but wonder if this was just an excuse to show off that you have a 7970 clocked at 1010MHz!

I read some time...

Jeff Moden (2/28/2013)

---

Shifting gears a bit, I’m glad that these are essay-style questions so that I could write in what I believe is a more correct answer in for question...

Thanks Brian. This article is extremely informative. I hate permissions in SQL but your approach is spot on for making it understandable.

nice article. key points covered very well.

we use TDE. we have about half the databases encrypted. the others are not.

i noticed less than 5% increase in CPU usage implemening TDE....

again, thank for clarifying that Paul...

so unless you have some hardcore redundancy, you most likely will always incur some data loss....

you can mitigate that loss by running DBCC CHECKDB often.

i...

thanks Paul,

so i take daily fulls at 2 am. I take logs every 15 minutes.

I run DBCC checks daily at 8pm and have processes in place to email me...

this is a great article about the perils of using the ALLOW_DATA_LOSS command, but i would be curious to know what Pauls recommendation are for a backup strategy.

when is the...