Viewing 15 posts - 9,661 through 9,675 (of 19,560 total)
george sibbald (6/17/2011)
Thanks for your input.
I think the type of work our devs are doing must differ greatly from yours (more ETL processes), and I have never had 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
June 17, 2011 at 10:13 am
Good
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
June 17, 2011 at 10:10 am
OK. Backward compatibility Tools for dts.
Try this article.
http://jasonbrimhall.info/2010/07/07/sql-2008-dts/
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
June 17, 2011 at 9:59 am
Out of curiosity, why? You could use the SQL 2008 stuff to connect to a SQL 2000 instance.
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
June 17, 2011 at 9:41 am
Presize the mdf will not affect the LDF / Log. Presize the Log file too.
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
June 17, 2011 at 9:30 am
When in simple recovery, your log file will grow if there is not enough space in the file to support active transactions. Once those transactions are committed, the file...
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
June 17, 2011 at 9:14 am
Grant Fritchey (6/17/2011)
george sibbald (6/17/2011)
quick straw poll if you don't mind guys -how much access should developers have in a development environment?
Sandbox - Everything, sa
Shared Environment - generally ddl_admin, security_admin,...
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
June 17, 2011 at 9:09 am
Craig Farrell (6/17/2011)
WayneS (6/16/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
June 17, 2011 at 9:06 am
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
June 17, 2011 at 9:03 am
retribution
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
June 17, 2011 at 8:59 am
Are you creating just one Unique index on those 4 fields? Just curious because you say that it is successful on the first three columns.
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
June 16, 2011 at 2:50 pm
GSquared (6/16/2011)
The Dixie Flatline (6/16/2011)
jcrawf02 (6/16/2011)
"You HAVE to click this link …. It is a video name generator and gives...
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
June 16, 2011 at 1:07 pm
Craig Farrell (6/16/2011)
jcrawf02 (6/16/2011)
GSquared (6/16/2011)
My dog chased a squirrel up my pants-leg one time.I'll take wild rodents over arachnids any day of the week.
One might kill me, but the 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
June 16, 2011 at 12:56 pm
Wow, thanks for posting that back.
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
June 16, 2011 at 12:47 pm
Steve Jones - SSC Editor (6/16/2011)
GilaMonster (6/16/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
June 16, 2011 at 12:06 pm
Viewing 15 posts - 9,661 through 9,675 (of 19,560 total)