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

If you run a trace on this query you will see that for every pair in the join it is calling the function. On top of that you are doing...

Sorry I have to say the whole DMZ thing is really out of my area. I know you need to open a hole in the firewall, but I leaveit to...

Is the WEB app in a DMZ? You will need to open ports in the firewall and probably NAT them to connect to the SQL Server. A good sys admin...