April 1st, the day when the internet loses its collective mind (did it ever have it to begin with?) and starts throwing out "jokes" (term used loosely, your sense of...

Quake

Detroit Tigers start swinging in about 1/2 an hour!

Guns, guns, guns. C'mon, Sal.

The Tigers are playing... [slaps the table]

tonight. I never miss a game.

😀

ChrisM@Work (3/31/2014)

---

Way back in the early 90's many of us FoxPro programmers waited with bated breath for MS' release of a product which included a crude implementation of SQL. After...

New Born DBA (3/28/2014)

---

samalex (3/28/2014)

---

One issue is the potential of one log or data file filling up the entire drive preventing the other data and log files from growing. ...

OK, thanks Gail.

Did some research when I first found this, thankfully the log files hadn't rolled over since everything was migrated to a new server. It looks like it's...

Also, here's the table definition and index definitions:

CREATE TABLE [dbo].[AllDocStreams](

[Id] [uniqueidentifier] NOT NULL,

[SiteId] [uniqueidentifier] NOT NULL,

[Content] [varbinary](max) NULL,

[RbsId] [varbinary](64) NULL,

[InternalVersion] [int] NOT NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

The indexes:

/****** Object: ...

Here you go Gail, and thanks!

Plus, I can restore the backup I took of the broken DB to start "fresh" if prefered / needed.

Msg 8939, Level 16, State 98, Line...

OK, so I tried running DBCC CHECKDB('DB',REPAIR_ALLOW_DATA_LOSS) on my problem DB (the copy, NOT production!)

Here's what I get back, again, snippets, it goes on for lines and lines and lines...

Msg...

Lynn Pettis (3/22/2014)

---

Just a guess, but I would think as long as you have the certificate used to encrypt the database with TDE it should not matter what backup software...

Well, today is going to be a big day for the wife and I, almost as big as when I switched jobs...

Today we meet with the builders to go over...

OK, I've got a thought then. It looks like, from reading the BOL on tokens, that they are for TSQL job steps. Try prefixing the command with the...

Couple questions about this:

1. Can you execute any other CMDEXEC steps? Ignore what you're trying to do, try something simple first, like "DIR > c:\temp\dirlist.txt" and see if...

GilaMonster (3/10/2014)

---

Jack Corbett (3/10/2014)

---

My job title is Data Software Development Leader. I'll be doing a lot of design and architecture work. I'm going to kind...

SQLDCH (2/28/2014)

---

I'd love to see a reboot of the Barsoom (John Carter) series by Edgar Rice Burroughs. Disney already made an attempt, but it was pretty bad, leaving out...