chumphrey 12211 (8/17/2012)

---

I'm wondering why if I delete an obsolete database that is currently active via SSMS that it also removes the data and log files but if the database...

Can you explain why you didn't just create a new filegroup with with the data file for that filegroup on the drive where you have the ARCH database and move...

How to: Upgrade to SQL Server 2008 R2

http://msdn.microsoft.com/en-us/library/ms144267(v=sql.105).aspx

davidandrews13 (8/10/2012)

---

there's an answer at the bottom of this page

http://msdn.microsoft.com/en-us/library/ms174979(v=sql.105).aspx

it states:

Allowing an extra comma after the last column definition makes the code easier to generate and maintain because all lines...

There is a lot to be said for just ignoring bad advice and doing things your own way, especially since you would be the one doing the recovery if things...

Be aware that you...

Fly Girl (8/10/2012)

---

Thanks very much, guys!

Interesting idea on the Read_Committed_Shapshot. The documentation says that 'most' applications can work with it without changes... Dun't, dun't duh... That and the issue that...

shamshad.ali (8/9/2012)

---

Hi,

Currently we are using SQL Server 2008 R2 on all environments (Client, Production, testing, developmenmt), but using SQL Server Reports developed in 2005 version. I have been assigned a...

I agree on the having a different account of each SQL Server with a long random password, but I think you need to store the password. I have seen...

Fly Girl (8/7/2012)

...

6, 7 & 9. A private consulting company had just done a review of db performance. From what they left from their traces & analysis the main culprit...

FunkyDexter (8/9/2012)

---

...I have an unusual interview technique I use which some here might find unreasonable but I'd defend it to the hilt. I get two sets of lego containing...

You wouldn't be able to use integrated security for access to the SQL Server, and the SQL Server would not be able to use a domain service account. There...

laurie-789651 (8/7/2012)

---

You need to pass the parameter to the sql.

I think this will work:

ALTER PROCEDURE [dbo].[TestSPR]

@P1 int

AS

BEGIN

SET NOCOUNT ON;

DECLARE @MyExec VARCHAR(100)

SET @MyExec = 'Select * from...

The declaration of @MyExec goes out of scope inside your EXEC (@MyExec).

If you want to pass variables to/from a dynamic SQL batch, use SP_EXECUTESQL.

"..Their support wrote back to me with a script to add some indexes on some columns. Of course, the columns weren't in this particular query, but hey, adding an index...