Viewing 15 posts - 16,171 through 16,185 (of 19,560 total)
Lynn Pettis (3/19/2010)
As for me, nope. First, I'm salaried, and second I am also a year-round employee; I don't get summers off.
All the better for a snow-day.
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
March 19, 2010 at 3:45 pm
john.arnott (3/19/2010)
Tom.Thomson (3/19/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
March 19, 2010 at 3:44 pm
GilaMonster (3/19/2010)
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
This is 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
March 19, 2010 at 3:39 pm
Dave Ballantyne (3/19/2010)
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
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
March 19, 2010 at 3:38 pm
I am going to post a blog on what I did with this script.
I made a bunch of changes to suit my needs. Some of which include the output...
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
March 19, 2010 at 2:49 pm
Lynn Pettis (3/19/2010)
crookj (3/19/2010)
Lynn Pettis (3/19/2010)
[font="Comic Sans MS"]Snow Day![/font]Lucky!
We still had to work - Guess D11 is scared of a few (million) snow flakes.
Joe
Explaination I got from my Executive Director...
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
March 19, 2010 at 2:41 pm
2005 also has a migration wizard.
Here is an article that may serve some usefulness.
http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/
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
March 19, 2010 at 2:19 pm
Lynn Pettis (3/19/2010)
CirquedeSQLeil (3/19/2010)
Found it faster than I expected.This one has a few other links on the same topic.
http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
I ask for a link, you provide it, and where do I...
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
March 19, 2010 at 1:59 pm
Lynn Pettis (3/19/2010)
And, you really should consider dropping the use of the NOLOCK hint everywhere. You may want to start by reading this: http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx.
Agreed - nolock can cause problems...
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
March 19, 2010 at 1:57 pm
Take a look at this article and see if it helps.
http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Databases
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
March 19, 2010 at 12:40 pm
john.arnott (3/19/2010)
I don't know that I should be embarrassed by having "missed" my own question, though.
Now I don't feel so bad:cool:
The point of it was to point out...
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
March 19, 2010 at 12:33 pm
Found it faster than I expected.
This one has a few other links on the same topic.
http://blogs.msdn.com/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
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
March 19, 2010 at 12:30 pm
Lynn Pettis (3/19/2010)
Anybody have some good links to why you should NOT use the NOLOCK hint? Seems everyone writing SELECT queries these days uses that everywhere.
I have noticed 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
March 19, 2010 at 12:28 pm
Paul White NZ (3/19/2010)
sistemas_casinomnes (3/19/2010)
and how can I do to avoid the second result ?
It depends on exactly what you are using to connect to SQL Server.
The more you tell...
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
March 19, 2010 at 12:27 pm
I agree with Paul. Eliminate the 5 from your FREETEXTTABLE query, and then implement the containstable.
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
March 19, 2010 at 12:25 pm
Viewing 15 posts - 16,171 through 16,185 (of 19,560 total)