One issue I consider fairly serious is the gaps in the Identity sequences when you restart the SQL Server Service (failovers etc). For a standard identity (1,1) you can get...

cciappa (6/29/2012)

---

So if I had inserted 85 rows and the last insert populated my identity column with 85, after restart the next insert produces an identity of 10,085. Again,...

GilaMonster (6/20/2012)

---

Sequences and...

My "on startup" procedure is a viable workaround here is the code as I tested it. Note that you need to enable the "scan for startup procs" configuration which requires...

I've done a bit of testing, and it doesn't increase by 1000, it increases to the next value greater than the last identity value using this formula: New Identity =...

Thanks, I also got a chance to test it fully this morning, both adding a CS Index and creating an availability group on a database with a CS Index.

It all...

Is there a particular reason you are going to Per-core licensing? Unless your ability to count devices/clients connecting has changed, or you have crossed the break even barrier on CALs...

Hi all,

I retried my cluster build with the data drives on each node having a different drive letter, but once again after configuring the cluster only the C: Drives were...

This may be an issue with SQL Server 2005 as the installer activly runs install scripts on the 2nd node when you install on the first node. So after the...

Are you trying to RUN the package or OPEN it? You should be opening it with Business Intelegence Development Studio.

Leo

jasona.work (4/17/2012)

---

I realize we could take Differential backups throughout the week (Tue-Fri,) which would capture only the updated / changed / added Filestream information, but there are office politics reasons...

Job history is stored in MSDB, the log you see is simply a view of the underlying tables. Restore MSDB under a different name from a backup covering the required...

Changing the SQL Virtual IP address is actually relatively easy, but does require down time. See this KB http://support.microsoft.com/kb/244980

I can't see any reason why the application should require you to...

I'd investigate the timeouts first as I suspect the TempDB issue is a symptom of...

This is not a lot of information to go on. How are you trying to see the database properties and what properties are you looking at? e.g. File size? Also...