Viewing 15 posts - 12,376 through 12,390 (of 19,560 total)
CirquedeSQLeil (9/15/2010)
jcrawf02 (9/15/2010)
bitbucket-25253 (9/15/2010)
By the way for some reason going down is always slower and harder than going up.
Couldn't have anything to do with the fact that you already climbed...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 2:48 pm
jcrawf02 (9/15/2010)
bitbucket-25253 (9/15/2010)
By the way for some reason going down is always slower and harder than going up.
Couldn't have anything to do with the fact that you already climbed the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 2:19 pm
Craig Farrell (9/15/2010)
CirquedeSQLeil (9/15/2010)
Steve Jones - Editor (9/15/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 12:53 pm
Nice article - thanks. Good examples.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 12:52 pm
Steve Jones - Editor (9/15/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 12:48 pm
I don't see any transaction blocks. Do you have begin trans and commit trans in the original code?
With eleven update statements, it could be useful to isolate each in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 10:34 am
sinus
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 10:16 am
chrisph (9/15/2010)
You...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:29 am
Alvin Ramard (9/15/2010)
CirquedeSQLeil (9/15/2010)
edit: quote engine did something funkySo you're saying the quote engine funked up? 😛
A tiny int
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:28 am
Brandie Tarvin (9/15/2010)
Nothing like being told by testers that your code is wrong, fixing it, having the vendor deploy it, being told again that the code is wrong, not understanding...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:27 am
Sounds like somebody used a bit field for gender and forgot to put a constraint on it. Now the gender is null and has confused the virtualization :-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:26 am
Do you get any errors in the event logs?
Is the maintenance plan being setup to run against a SQL server, or are you trying to connect it to some other...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:24 am
Brandie Tarvin (9/15/2010)
[font="Verdana"]We're sorry. The user you are attempting to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:22 am
WayneS (9/15/2010)
CirquedeSQLeil (9/14/2010)
WayneS (9/14/2010)
assh1122 (9/14/2010)
Thank you both for taking your time to answer my question. I could able to successfully change the table owner using the sp_changeobjectowner '[currentschema].[currenttable]' , 'dbo'...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:16 am
GilaMonster (9/15/2010)
Brandie Tarvin (9/15/2010)
GilaMonster (9/15/2010)
SELECT [No biltong] = 'Absolute, total disaster'
I tried your code. It does not compute.
Msg 257, Level 16, State 3, Line 2
Implicit conversion from data type varchar...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 15, 2010 at 9:12 am
Viewing 15 posts - 12,376 through 12,390 (of 19,560 total)