Viewing 15 posts - 18,106 through 18,120 (of 19,560 total)
Most excellent. Thanks for the update.
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
January 15, 2010 at 4:11 pm
I could imagine. I have come into jobs where we had to replace a bunch of DTA indexes. Similar exercise. Pain in the butt - and very...
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
January 15, 2010 at 4:10 pm
TheSQLGuru (1/15/2010)
CirquedeSQLeil (1/15/2010)
gmby (1/15/2010)
lol, I've got a database that has a few of those runaway DTA indexes (all columns included) -
I've seen that as well. Nice 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
January 15, 2010 at 3:25 pm
dba_neo (1/15/2010)
By running the dbcc checkdb() repair_allow_data_loss,the data will be lost.as i dont have the backup of DB
Potentially lost. Data may be lost - it depends on how bad...
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
January 15, 2010 at 1:32 pm
Gail provides some very good points. She provided a link about Dirty Reads, you should read that article. Tuning queries, indexes, and database design should be the approach...
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
January 15, 2010 at 1:30 pm
gmby (1/15/2010)
lol, I've got a database that has a few of those runaway DTA indexes (all columns included) -
I've seen that as well. Nice to run 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
January 15, 2010 at 1:22 pm
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Med).
Your output is suggesting that you run the above repair option at a minimum. Do you...
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
January 15, 2010 at 1:13 pm
Lynn Pettis (1/15/2010)
Love you must the easy ones.
nice
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
January 15, 2010 at 1:02 pm
Chris Quinn-821458 (1/15/2010)
CirquedeSQLeil (1/15/2010)
...... 1
You may be down to 1, but I have a feeling that there will be no work done 😀
You would lose the bet - 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
January 15, 2010 at 10:51 am
I saw posted in another thread the suggestion of Creating an alternative user to replace SA. Leave SA in place - but decrease its permissions.
That might assist you somewhat...
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
January 15, 2010 at 10:49 am
Most excellent. Glad to be of service.
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
January 15, 2010 at 10:45 am
is250sp (1/15/2010)
wow this works but there's so many AND's and OR's it's confusing trying to decipher it. thanks!
You're welcome. It's an interesting scenario.
As Lynn said, the query could...
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
January 15, 2010 at 10:37 am
Here is a link that covers several datetime conversions.
http://www.sqlusa.com/bestpractices2005/sqlserverstringtodate/
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
January 15, 2010 at 9:10 am
I wouldn't do it.
As an alternative, maybe you could do a Full-text index on that column.
It will be an expensive Index (Generally speaking) if you do decide to create...
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
January 15, 2010 at 9:07 am
You will want to check for CPU utilization, memory utilization, disk IO, disk space for starters.
Depending on usage will get you number of servers you can consolidate.
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
January 15, 2010 at 1:01 am
Viewing 15 posts - 18,106 through 18,120 (of 19,560 total)