Viewing 15 posts - 46,276 through 46,290 (of 49,571 total)
Bart Read (6/11/2008)
SQL Prompt does support this, but you need to switch it on.
:blush:
Thanks. Somehow I've missed that every time I looked at the options....
June 11, 2008 at 6:23 am
Grant Fritchey (6/11/2008)
You are quick, Gail! I haven't even been able to download the bloody thing yet, let alone get my virtual's upgraded.
Not me actually. I'll be installing it tonight....
June 11, 2008 at 6:13 am
guptaajay1985 (6/10/2008)
Please...
June 11, 2008 at 5:31 am
I just checked SQL 2008 RC0 and the intellisense (and syntax checking) only works to a SQL 2008 server. :angry:
This was one of the features I was really, really looking...
June 11, 2008 at 5:17 am
I'm still not understanding the reason for the detach. If your security is set up properly, a detached database is no more secure than an attached one.
Still....
You're probably getting...
June 11, 2008 at 5:08 am
UDBNT (6/11/2008)
Not sure on the validity of (nolock) on a table where you are deleting data?
The hint will be ignored. Deletes have to lock exclusivly, lock hints or no lock...
June 11, 2008 at 5:06 am
Be patient. We're not paid to answer questions here.
June 11, 2008 at 5:05 am
Index definitions?
Has the total number of rows in the table changed since this worked properly?
Are your indexes fragmented? Are the statistics out of date?
I'm not asking just to be a...
June 11, 2008 at 5:00 am
how many rows is that delete likely to affect?
What indexes do you have on the 2 tables?
June 11, 2008 at 2:56 am
Dave (6/10/2008)
June 11, 2008 at 1:25 am
Please don't cross post. It wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to
June 10, 2008 at 1:07 pm
riga1966 (6/10/2008)
What is this Table 'Worktable'?
Is it because it's SQL 2005?
It's a temp table created and used by the query processor to store portions of the result set during processing....
June 10, 2008 at 12:14 pm
Firstly, I would suggest you take the people responsible for that absurd standard out and shoot them repeatedly. 😉 :hehe:
Seriously now...
How active is the db in question? (transactions/sec)
Is it more...
June 10, 2008 at 12:08 pm
It can, but then you have all the downsides of dynamic SQL. (permissions, proc cache growth, possible SQL injection)
For something like this, probably 2 procs is easier. For something like...
June 10, 2008 at 12:01 pm
Viewing 15 posts - 46,276 through 46,290 (of 49,571 total)