Viewing 15 posts - 12,301 through 12,315 (of 19,560 total)
Bhuvnesh (9/17/2010)
CirquedeSQLeil (9/16/2010)
Another option is to use SSIS and kick off the job through SSIS - use connection managers for each different server and kick off the jobs from there.
...
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 17, 2010 at 8:36 am
It wasn't to make it run faster, but potentially lower the chance of contention.
How many records in the affected tables? Table ddl? Index structures? Can you provide...
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 17, 2010 at 8:30 am
Brandie Tarvin (9/17/2010)
gonickl (9/16/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 17, 2010 at 8:28 am
DMV
As in worst in the country reside in Las Vegas
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 17, 2010 at 8:27 am
Lynn Pettis (9/17/2010)
GilaMonster (9/17/2010)
WayneS (9/17/2010)
Steve Jones - Editor (9/14/2010)
- he was abused
- I contributed 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 17, 2010 at 8:23 am
thanks for the 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
September 16, 2010 at 11:57 pm
That's probably the tool.
And yes it is odd for the sites to have different names for the tools.
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 16, 2010 at 11:45 pm
Jeff's response should help you fix that. You can use the convert function in TSQL to change the int data type to a varchar or char (string) datatype so...
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 16, 2010 at 11:04 pm
what was the statement that you used for isnull?
What is the datatype that has null values in the database?
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 16, 2010 at 9:39 pm
Another option is to use SSIS and kick off the job through SSIS - use connection managers for each different server and kick off the jobs from there.
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 16, 2010 at 4:33 pm
Edoggs method should work
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 16, 2010 at 4:33 pm
homebrew01 (9/16/2010)
sqlbuddy123 (9/16/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 16, 2010 at 3:42 pm
GilaMonster (9/16/2010)
Richard M. (9/16/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 16, 2010 at 3:39 pm
Stefan Krzywicki (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
'postro-fees are also used to show a bit o' an accent.
Still a contraction (left out letters)
Where they should NOT be used..
In fantasy/sci-fi 'languages...
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 16, 2010 at 3:36 pm
Alvin Ramard (9/16/2010)
Jeff Moden (9/16/2010)
Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?He's finally learnt to spell properly. 😀
Perhaps a course...
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 16, 2010 at 3:06 pm
Viewing 15 posts - 12,301 through 12,315 (of 19,560 total)