dba.nivali (12/11/2009)

---

I did try all this .

is there anyway before i can remove the identity column as non - identity

after insert i can change it to identity...

I've been using since the day after it was released on my 64 bit servers.

I missed that you said CIFS in conjunction with UNC. The supported way for doing this would be a IPSEC tunnel or point to point VPN between the machines,...

What I'd do is have a dedicated NIC on the SQL Server to handle pushing the backups to the UNC path. This would segregate the Network IO from the...

chad.henningfeld (12/10/2009)

---

I appolgize for not being clear with the issue, i was off in what i was looking for it was a problem within the .net code. So even if...

Lynn,

Thats so unfortunate. Our group meets on Tuesdays which tends to be a good night for most people. Monday is never a good day to do it, IMO,...

Jeff Moden (12/9/2009)

---

As a side bar... make it company policy that there's a $5 charge for this just as if they'd lost their badge. One of two things will...

The only other thing to do would be join your local user group. In Tampa, we have a email list through yahoo groups that recruiters and members post job...

Note that I use a certificate signed assembly and a certificate login in that example as well. I'd forgo CLR for this, you can accomplish it with SQL Agent...

Without knowing more information it is impossible to tell you good or bad. How long has the server been up? If those numbers are aggregate over 2 months,...

One thing I didn't mention is that if you are using an Alias, they have to be setup initially and the application has to be configured to use the Alias....

Interesting that you mention checkpoint here. I considered that but couldn't remember enough about it to know...

I asked Paul Randal your question because I know there are potentially other things that would do it, but I don't know for sure what exactly those might be beyond...

For IO_Stalls, as close to zero as possible. Stalls = bad performance/high latency to disk.

For SQL 2005 look at the following Engine Team Blog posts:

TempDB Monitoring and Troubleshooting: Allocation...

If you only have a SQL 2005 environment then either works. I like scripts because I can automate things with them and they are predictable. If you use...