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'

Well here's another point of view from someone who's not in accounting or financial.

I need to display to customer the current available inventory and the price for their account.

Under no...

george sibbald (5/1/2010)

---

The search criteria on the where clause is used by SQL to determine optimum plan, not the select list.

Post your create table script, sample values and the execution...

Cnu2010 (4/30/2010)

---

For a given County, I am returning the cities in that County

SELECT DISTINCT CITY FROM DEMO WHERE COUNTY = @COUNTY

CITY

-----

EDINA

BLOOMINGTON

EDEN PRAIRIE

SHAKOPEE

How do I display this data in a row...