Viewing 15 posts - 46,561 through 46,575 (of 49,571 total)
Did you comment the insert out as well?
This parses. It won't run, cause I don't have the tables, but it does parse.
CREATE TABLE #XYZ(
NTUser varchar(20),
FullNTName varchar(50),
FirstName varchar(20),
MiddleName varchar(20),
LastName varchar(40),
Rolename varchar(30))
DECLARE...
May 14, 2008 at 11:46 am
Replace the EXEC with a PRINT and have a look at what the constructed SQL statement is. You should be able to spot syntax errors fairly easily that way.
May 14, 2008 at 11:27 am
Please don't cross post. It just wastes people's time and fragments replies.
Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic500696-146-1.aspx
May 14, 2008 at 11:25 am
jamiejulius (5/14/2008)
In reference to the idea of changing the Recovery Model, are you suggesting that this would reduce the frequency and/or duration of the checkpoints?
No. It won't. All it will...
May 14, 2008 at 8:10 am
Hans Lindgren (5/14/2008)
But I would argue that no application with these number of hits would not have connection pooling turned off and serializing all DB access..
I have a rule when...
May 14, 2008 at 8:09 am
Jonathan Mallia (5/14/2008)
You might consider switching the database to simple recovery model if possible.....
And lose the ability to do point-in-time recoveries.
Why do you suggest that?
May 14, 2008 at 7:41 am
This is the 3rd year I've submitted. No luck so far. Will see.
May 14, 2008 at 6:43 am
Not that I know of. Inserts happen in a batch. If one row fails the entire batch will fail.
Your best bet is validating the data before you try inserting it.
May 14, 2008 at 6:42 am
May 14, 2008 at 6:40 am
Switch the order of this index, or create a new one
mgr_acc - Non clulstred index on mgr_28B_code,bintent,b_id - 11160 rows
Change to Bintent, b_id, mgr_28B_code
or
b_id,...
May 14, 2008 at 6:38 am
Please don't cross post. It just wastes people's time.
Already answered-
http://www.sqlservercentral.com/Forums/Topic500298-65-1.aspx
May 14, 2008 at 6:30 am
As a hopeful speaker, I second the above. Prizes are nice, but the party's plain good fun.
Do you know why PASS changed the way things were done re the codes?
Steve,...
May 14, 2008 at 6:26 am
Make sure you rebuild all your indexes after the shrink. Shrinking a database badly fragmetns indexes.
May 14, 2008 at 6:21 am
Maybe.
Check that your indexes are not fragmented and that your statistics are up to date.
Check that implicit transactions is not a connection default.
You can check the execution plan of the...
May 14, 2008 at 2:54 am
Christopher Stobbs (5/14/2008)
Thanks for the reply.That what I would expect to happen.
The current table count is 5.
So if I make it 0 it should be 5+1 which is 6.
No, if...
May 14, 2008 at 2:50 am
Viewing 15 posts - 46,561 through 46,575 (of 49,571 total)