Viewing 15 posts - 3,721 through 3,735 (of 7,168 total)
Jeff Moden (6/26/2012)
Jeff Moden (6/26/2012)
opc.three (6/26/2012)
Keeping all data in one table, but using a separate filegroup for blobs is a good way to go, and simple.
Actually, it's not. I...
June 26, 2012 at 4:32 pm
SQL_Surfer (6/26/2012)
Autogrow. I had created a DMP to update statistics and rebuild index. Thats when db grew.
Thanks for the response. You said you were in FULL recovery mode. In between...
June 26, 2012 at 3:09 pm
Are you manually growing your database files on a regular basis, or are your database files auto-growing regularly? What made you realize you were running low on disk space? When...
June 26, 2012 at 2:57 pm
ScottPletcher (6/26/2012)
June 26, 2012 at 2:43 pm
Yes, I did, and I am sure a lot of other people have as well. The people that leave reviews on Amazon are the ones that used the book as...
June 26, 2012 at 2:32 pm
robert.tuniewicz (6/26/2012)
SQL2, 3 and 4
Edition: Enterprise Edition 64bit
Product/Version: 10.0.4311
ProductLevel: SP2
on SQL1
Edition: Enterprise Edition 64bit
Product/Version: 10.0.4064
ProductLevel: SP2
SQL1 and 2 are in a cluster. So when I...
June 26, 2012 at 1:38 pm
Can you please post the results of this from all 4 instances, so we're all on the same page?
SELECT SERVERPROPERTY('Edition') AS Edition,
...
June 26, 2012 at 1:09 pm
robert.tuniewicz (6/26/2012)
SQL1 & SQL 2 are part of of Windows 2008 R2 Cluster.
SQL3 is my...
June 26, 2012 at 12:53 pm
Basic question, maybe nothing, but you gave us the generic error message:
"...Cannot insert duplicate key row in object 'TableName' with unique index 'IndexName'..."
Do the TableName and IndexName pertain to the...
June 26, 2012 at 12:26 pm
Keeping all data in one table, but using a separate filegroup for blobs is a good way to go, and simple.
CREATE TABLE dbo.Personnel
(
PersonnelID INT NOT NULL
...
June 26, 2012 at 12:17 pm
Yes, it is a picture of Robert Hays as Ted Striker. I am not sure if you can see the detail in the picture but it's from the scene when...
June 26, 2012 at 11:41 am
schleep (6/26/2012)
Confirmed.Set-Location SQLSERVER:\SQL\MyServer\Default\Databases\MyDB\StoredProcedures
dir | select name
does not return any system sprocs. I wonder why the repl sprocs would fall into the user category.
Weird...
P
Indeed. This was quite an entertaining exercise nonetheless...
June 26, 2012 at 11:08 am
From the OP's code, modified for my machine for demo:
Add-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue
Add-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue
Set-Location SQLSERVER:\SQL\MyComputer\MyInstanceName\Databases\MyDataseName\StoredProcedures
Get-ChildItem | Select Name
I only receive a list of user-defined procs.
June 26, 2012 at 9:58 am
Issuing separate logins for separate responsibilities to the report writers would allow you to cordon off certain DBs for certain logins they are issued.
Or you could tell them to stop...
June 26, 2012 at 8:13 am
Viewing 15 posts - 3,721 through 3,735 (of 7,168 total)