never heard of this locking code before today. it looks like a calculated value created by the program ecoid.exe.

the program echoid.exe is not a Windows included executable, so of...

if you can do it to one row, even if you are doing it in multiple steps now,...

satya.sakamuri (5/11/2010)

---

Hi,,

could anyone help me how to identify which tables in your database may need additional indexes?

in my databse there are 200 tables ech contails aroud 15 columns adn...

my copy/paste of your query shows it to be syntactically correct; i don't see a problem with it;

if you change the query to a sample query, does it work and...

a basic example might be Addresses; a normailzed database would pull out CITY and STATE to seperate tables, so your ADDRESS table would have CITYID and STATEID instead of the...

database scope, i'm sure; did you open a new query window(which might be defaulted to the master database?

the query would fail because our ''WEB_CATALOG_IMAGES' table doesn't exist in master.

change the...

satya.sakamuri (5/11/2010)

---

Thanx Lowel,

i selected the database whic i want to perform inthe place master.

i was wondering do i need to create a new folder in the browse for a...

yes you can, but first you would have to have set up database mail on your server.

in SSMS,expand the "Management Folder" and find Database Mail. you have to know the...

you add indexes to enhance performance based on the queries that hit the server;

for example, if a table is often searched by the column LastName, an index on that column...

doh! Gianluca hit it! 16 seconds if i don't present the results in SSMS. i feel better now.

Gianluca Sartori (5/11/2010)

---

I get:

19 seconds for the first run

16 seconds for the second...

Jeff Moden (5/11/2010)

---

1.6 million random 8 character codes that no one can guess and they're guaranteed to be unique within the set... takes about 25 seconds on my 8 year...

man i love details! with your explanation, it looks so easy now!

I think i have what you want; run this select and confirm whether or not this is finding what...

pseudo code (TableA TableB etc) sux. i don't think it can describe a real resolution for you. moving concepts from pseudo code to your real issue is stopping you from...

the logic is the same...it's just the test condition that changes:

don't think you wan t not exists...you want to confirm that there is at least one row on TableC...

it's actually easy..you can use multiple AND/OR statements with an IF:

IF NOT EXISTS(SELECT 1 FROM TABLEA WHERE ID=1)

AND NOT EXISTS(SELECT 1...