[set beginner lvl on]

What?

[set beginner lvl off]

I've read about transaction isolations but I don't know what you're asking.

Lynn Pettis (5/10/2010)

---

My question is why are they debugging in production? If there is a problem, they should have a test environment in which to test and debug issues...

Lynn Pettis (5/10/2010)

---

My question is why are they debugging in production? If there is a problem, they should have a test environment in which to test and debug issues...

Hey guys I need your help to protect my website from other consultants (who should know better but don't).

High {no} availability and UPDLOCK

Well here it is :

http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/%5B/url%5D

Well yes but...

This is because of parameter sniffing and / or safe plans.

The server has the assume that start date and end date will change. Also once the tipping point is...

neddyflanders (2/1/2005)

---

Just for my own information. I'm new to T-SQL and have been using alters to change columns etc. Have been told sometimes you might want to drop and recreate...

I found a little annoyance in the script... it doesn't print out if you have less than 4000 characters. I added the if before the loop and now all...

bteraberry (5/6/2010)

---

I don't see a problem with the IsActive bit field. Why do you think that's where the problem lies and how sure are you of that?

It's a little...

Holy sh***it only 2% of correct answers as of now (I'm in the mojority of course...

Wow, thanks a million.

I have to "duplicate" my queries dynamically for reporting. My customer has 30 incorporations and each of them has it's own set of tables in the...

Lynn Pettis (5/3/2010)

---

stark 41816 (5/3/2010)

---

Hi Lynn,

thank you for your fast reply.

Looking at your code, you use async sql operations to update and re-read:

update ....

select ....

Without locking,...

Gianluca Sartori (5/3/2010)

---

SQL Server doesn't need a front-end, it just needs a client connectivity library to be installed.

If you are using a front end, probably you have Access forms, so...

I know I'm 2 years behind, but on sql 2008 I need to do this to use sp_msforeachdb :

sp_msforeachdb 'use [?]; dbcc showfilestats'