stormsentinelcammy (2/20/2014)

---

Agree about having the performance stats before doing any change/tuning/indexing/stats revision, etc...

I usually take a production copy of a database where I can benchmark to what an actual user...

Sl33py (10/30/2013)

I want to know. when I right click on databases and select restore from device, I click add and it takes a long time before anything is displayed +-...

Bradley McGuffey (10/29/2013)

---

I'm going to put myself out there as the possible idiot developer who is having the same issue. Here is my connection string, which does not have the...

I like to use a script Michelle Ufford wrote and posted on her blog:

SQL Agent Job Script[/url].

I make modifications to that to add/remove additional data as needed.

The error provided is not associated with SQL Server Agent not starting, you normally see it when trying to start the SQL Server Service.

You will likely find that the SQL...

Installing on the C drive would be sufficient for me in that situation.

I do my best to not install any part of SQL Server on the operating system drive. SQL Server is basically it's own "operating system" as you will find some...

bathawes 16438 (10/26/2011)

---

Just to follow up on this:

I was given this formula to use although I haven't yet confirmed it is correct:

(CAST (value_in_use AS INT)/1024/4)*300 FROM sys.configurations WHERE NAME =...

For folks that come across this post...

NZ() function is not available outside of Access so you can't use it in SSIS. What I came across was having to do something...

This can depend on how you document your systems. You do document them right? 😀

I support a branch of the military, and the organization I support right now has requirements...

I can't attest to SQL 2008...

SQL Server Management tools (SSMS, BIDS) are going to be 32-bit installations. There is no version of BIDS and SSMS available in 64bit. You will probably find it a bit...

Since this comes up first in the list on Google I thought I would add a few notes...

There is only 1 book published by Sybex that I have seen that...

What is the exact build number of your instance?

This column is not to show locks, it is to show what SQL...

Ah. Ok, but the OP actually wants to create a new role from the permissions of a current role. So...