Viewing 15 posts - 17,236 through 17,250 (of 19,560 total)
Paul White (2/16/2010)
CirquedeSQLeil (2/16/2010)
I want a Hippopotamus for ChristmasOnly a Hippopotamus will do...
This strikes me as very funny - but I'm not sure why. Am I missing a reference,...
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
February 16, 2010 at 11:23 pm
WayneS (2/16/2010)
Anybody interested in reviewing an article on the ROW_NUMBER() ranking function? It's in a .doc file. PM me if interested.
Sounds fun. You know my email address.
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
February 16, 2010 at 11:08 pm
Lynn Pettis (2/16/2010)
CirquedeSQLeil (2/16/2010)
Lynn Pettis (2/16/2010)
Kind of got a bit heated, didn't it.I think that is a bit understated.
Did you see that hippo I left for you outside your tent?
Sure...
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
February 16, 2010 at 11:07 pm
Paul White (2/16/2010)
Lynn Pettis (2/16/2010)
Kind of got a bit heated, didn't it.
Yes. I've just read every post in that thread, and the previous posts by 'GT' referenced by Gail...
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
February 16, 2010 at 11:05 pm
Lynn Pettis (2/16/2010)
Kind of got a bit heated, didn't it.
I think that is a bit understated.
Did you see that hippo I left for you outside your tent?
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
February 16, 2010 at 10:09 pm
Steve Jones - Editor (2/16/2010)
I want an dolphin to take me away from all this, ride the waves and chase the sun.
As long as a pork chop flinging hippo can...
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
February 16, 2010 at 10:08 pm
I still do not consider it a long amount of time to insert 1 record.
That said, I would still find a way to break up your data into batches. ...
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
February 16, 2010 at 10:06 pm
Anam Verma (2/16/2010)
How many indexes do you have?
There are total of 5 indexes on this table
- 1 clustered as primary key
- 3 non clustered created on foreign keys
- 1 non...
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
February 16, 2010 at 9:10 pm
Yes, yes it did. The thread got enough juice today for several months. 😀
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
February 16, 2010 at 9:08 pm
As Jeff mentions Indexes - it is a valid point that indexes will have an impact on length of time to insert records.
If i were inserting these records one at...
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
February 16, 2010 at 9:05 pm
Elliott W (2/16/2010)
CirquedeSQLeil (2/16/2010)
WayneS (2/16/2010)
CirquedeSQLeil (2/16/2010)
... I use one instance of SSIS 2008 to perform various tasks against all of my 2000, 2005 and 2008 databases...
Hey Jason, how about...
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
February 16, 2010 at 7:58 pm
That isn't bad either. If it were 12 seconds, or maybe even 1 second then we could start to find a performance problem. IMO.
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
February 16, 2010 at 7:53 pm
WayneS (2/16/2010)
CirquedeSQLeil (2/16/2010)
... I use one instance of SSIS 2008 to perform various tasks against all of my 2000, 2005 and 2008 databases...
Hey Jason, how about an article about...
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
February 16, 2010 at 6:42 pm
You do realize how fast that really is
A microsecond is an SI unit of time equal to one millionth (10-6) of a second.
A microsecond is equal to 1000 nanoseconds or...
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
February 16, 2010 at 6:38 pm
Thanks Jeff - LMAO.
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
February 16, 2010 at 6:02 pm
Viewing 15 posts - 17,236 through 17,250 (of 19,560 total)