Viewing 15 posts - 8,986 through 9,000 (of 19,560 total)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
Posted. Overall, I am quite pleased with TVPs
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
August 18, 2011 at 1:00 pm
Much the same as table variables, large datasets can become problematic.
However, it depends on what you are coming from. We switched to TVPs from string splitting and saw huge...
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
August 18, 2011 at 12:58 pm
Do you need a script that will just display the memberships and security for that user.
Or do you need something that will generate the scripts to recreate that user with...
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
August 18, 2011 at 12:54 pm
jcrawf02 (8/18/2011)
for you writin' types: http://feeds.arstechnica.com/~r/arstechnica/everything/~3/kqUVb9dVkRc/ars-technica-is-looking-for-an-it-editor.ars
Oooh - that could be fun - must have experience.
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
August 18, 2011 at 12:49 pm
Nice analogy
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
August 18, 2011 at 12:48 pm
Ninja's_RGR'us (8/18/2011)
I've possibly discovered a bug that corrupts your db when doing a deployment script. I've tested on 2K5 sp3 and 2K8 R2 RTM,...
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
August 18, 2011 at 11:59 am
tim_harkin (8/18/2011)
On other benefit of studying for the certs is that I will learn more about features that I do not use regularly.
That is a definite perk.
I would add...
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
August 18, 2011 at 10:56 am
Well, I found what was causing my solution to run slower. It was relative to that dynamic numbers table but not how I expected.
By removing the selection against 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
August 18, 2011 at 10:51 am
Try this
http://www.sqlservercentral.com/search/?q=backup+all+databases&t=s
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
August 18, 2011 at 10:05 am
I can see more as to why it is puzzling.
Have you checked all the firewall and nic settings on the destination server?
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
August 18, 2011 at 9:45 am
Ha - I love it.
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
August 18, 2011 at 9:44 am
Cadavre (8/18/2011)
SQLRNNR (8/18/2011)
Cadavre (8/18/2011)
SQLRNNR (8/18/2011)
I need to delve a bit more into it...
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
August 18, 2011 at 9:43 am
Woot - nice question.
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
August 18, 2011 at 9:41 am
Cadavre (8/18/2011)
SQLRNNR (8/18/2011)
Well, that is about 12 times faster on my machine. Where did you pick up that trick?I need to delve a bit more into it now.
Not really...
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
August 18, 2011 at 9:37 am
Alex Webber (8/18/2011)
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
August 18, 2011 at 9:36 am
Viewing 15 posts - 8,986 through 9,000 (of 19,560 total)