Viewing 15 posts - 12,436 through 12,450 (of 19,560 total)
For each object in the database
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 13, 2010 at 9:35 pm
Nice question - thanks.
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 13, 2010 at 9:32 pm
TheSQLGuru (9/13/2010)
Can I ask why everyone is putting their code inside a UDF? Can't the code just be inlined as necessary?
The only explanation I can muster for that is...
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 13, 2010 at 9:30 pm
Doh, just read the last couple of comments. Would you point your finger of shame at yourself? :cool::cool:
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 13, 2010 at 9:28 pm
Lynn Pettis (9/13/2010)
Read the BIT Thread, what a crock!
That was a mouthful - wait, that would be a byte. I guess that thread was only a Bit of a...
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 13, 2010 at 9:26 pm
You're welcome and glad to help.
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 13, 2010 at 7:35 pm
It's good that people have this code working in some small facet. Don't ignore the warnings of the forum though about making absolute certain that the bit conditions meet...
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 13, 2010 at 7:26 pm
WayneS (9/13/2010)
FYI, we now need 22.4 posts/day to make 20k by Nov 18.
And Gail is still at 16.5. Recent additional thread posts pushed it down to 22.3.
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 13, 2010 at 7:25 pm
WayneS (9/13/2010)
Stefan Krzywicki (9/13/2010)
CirquedeSQLeil (9/13/2010)
Stefan Krzywicki (9/13/2010)
WayneS (9/13/2010)
Alvin Ramard (9/13/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 13, 2010 at 7:20 pm
Stefan Krzywicki (9/13/2010)
WayneS (9/13/2010)
Alvin Ramard (9/13/2010)
I'm staying out of that Bit thread, and I'm not the author of that saying, so feel free to post it if you want.
I tried...
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 13, 2010 at 7:03 pm
WayneS (9/13/2010)
Alvin Ramard (9/13/2010)
I'm staying out of that Bit thread, and I'm not the author of that saying, so feel free to post it if you want.
I tried to stay...
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 13, 2010 at 7:01 pm
bcsims 90437 (9/13/2010)
Steve Jones - Editor (9/13/2010)
I don't often take the dogs, but they like the 2-3 mile runs I do.16 miles, haven't done that in a long time.
I like...
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 13, 2010 at 5:48 pm
Steve Jones - Editor (9/13/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 13, 2010 at 5:45 pm
Trey Staker (9/13/2010)
CirquedeSQLeil (9/13/2010)
Trey Staker (9/13/2010)
Alvin Ramard (9/13/2010)
"There are 10 types of people in the world. Those that understand...
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 13, 2010 at 4:52 pm
Trey Staker (9/13/2010)
Alvin Ramard (9/13/2010)
"There are 10 types of people in the world. Those that understand binary, and those...
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 13, 2010 at 4:26 pm
Viewing 15 posts - 12,436 through 12,450 (of 19,560 total)