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...

ScottPletcher (6/26/2012)

---

You lose the db as it exists if a RAID1 fails, but if you place the files properly on the two RAID1s, the db can be fully recovered, which...

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...

Exam 70-433: TS: Microsoft SQL Server 2008, Database Development > Preparation Materials

robert.tuniewicz (6/26/2012)

---

The result of that query is:

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...

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,

...

robert.tuniewicz (6/26/2012)

---

I have 4 SQL Servers in my environment, SQL1, SQL2, SQL 3 and SQL4.

SQL1 & SQL 2 are part of of Windows 2008 R2 Cluster.

SQL3 is my...

Basic question, maybe nothing, but you gave us the generic error message:

Do the TableName and IndexName pertain to the...

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

...

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...

Indeed. This was quite an entertaining exercise nonetheless...

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.

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...

The messages logged by SQL Agent are limited, and formatting is removed making it difficult to read. Might I suggest piping the output of your job step to a file...

That brings up a good point. I have replication enabled in my...