Viewing 15 posts - 18,481 through 18,495 (of 19,560 total)
Grant Fritchey (12/23/2009)
GilaMonster (12/23/2009)
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.Time to fetch the chain-saw?
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
December 23, 2009 at 11:42 am
GilaMonster (12/23/2009)
Grant Fritchey (12/23/2009)
Fighting with a messed up development deployment. I love when developers mix up scripts from multiple versions of the database.Time to fetch the chain-saw?
Pork-chops and TNT...
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
December 23, 2009 at 11:36 am
sureshdeenu (12/23/2009)
Greg, after logging ON, where exactly i need to find the Log to look for error in sql server.
You would be setting your DTS to write it's error log...
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
December 23, 2009 at 11:35 am
One of two methods come to mind:
1. Use this command in an SSIS task and then do some transformations on it prior to inputting the data into the table.
2....
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
December 23, 2009 at 11:32 am
GSquared (12/23/2009)
I will run stat updates after index reorgs (not rebuilds, would be redundant).
This is typically what I do.
Grant
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
December 23, 2009 at 11:31 am
You're welcome and NP.
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
December 23, 2009 at 11:22 am
GSquared (12/23/2009)
CirquedeSQLeil (12/23/2009)
10 am here - and not seeing a rousing response about work.Next question is: Who has mentally checked out for the holidays?
This question assumes I ever mentally...
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
December 23, 2009 at 11:21 am
Matt Miller (#4) (12/23/2009)
Roy Ernest (12/23/2009)
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
December 23, 2009 at 11:20 am
Here is the related contents of that XP
// Set the Creation Date column in YYYYMMDD format
record.SetSqlString(2,f.CreationTime.ToString("yyyyMMdd"));
// Set the Creation Time column in HHMMSS
record.SetSqlString(3,f.CreationTime.ToString("HHmmss"));
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
December 23, 2009 at 11:11 am
10 am here - and not seeing a rousing response about work.
Next question is: Who has mentally checked out for the holidays?
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
December 23, 2009 at 11:06 am
tosscrosby-60625 (12/23/2009)
CirquedeSQLeil (12/22/2009)
Boot - as in what is done after over indulging.Boot or toot??? 😀
celebrating the "real" reason for the season!
However, the toot may come out as well.
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
December 23, 2009 at 10:53 am
tosscrosby-60625 (12/23/2009)
CirquedeSQLeil (12/22/2009)
Boot - as in what is done after over indulging.Boot or toot??? 😀
celebrating the "real" reason for the season!
As in slang used to represent oral projectiles thrust outward...
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
December 23, 2009 at 10:52 am
Today is the 23rd, and several we know are on vacation.
So, who is really working??
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
December 23, 2009 at 10:41 am
Most excellent
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
December 23, 2009 at 10:37 am
sublime
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
December 23, 2009 at 10:36 am
Viewing 15 posts - 18,481 through 18,495 (of 19,560 total)