Viewing 15 posts - 13,096 through 13,110 (of 19,560 total)
crookj (7/28/2010)
Brandie Tarvin (7/28/2010)
Ray K (7/28/2010)
crookj (7/28/2010)
19. Daisy (Our dog that runs the house - we are her servants)
We have two cats, Pepper and Nutmeg. There are some days...
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
July 28, 2010 at 10:47 am
I could imagine offering that level of service to some places.
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
July 28, 2010 at 10:42 am
GilaMonster (7/28/2010)
CirquedeSQLeil (7/28/2010)
You jest, but there was an answer in the forums again this week advocating the dropping of the log file.The one I went ballistic over or another?
You responded....
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
July 28, 2010 at 10:35 am
bitbucket-25253 (7/28/2010)
Are the OPs getting bummer and dumber or just lazy and lazier, have others noticed this behavior with fellow workers?http://www.sqlservercentral.com/Forums/Topic960056-146-1.aspx?Update=1
I have seen a slew of these types this week...
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
July 28, 2010 at 10:31 am
There is no single answer for your question.
It is best to be honest in your interview. If you don't have the experience and you try to answer as if...
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
July 28, 2010 at 10:29 am
Alvin Ramard (7/28/2010)
GilaMonster (7/28/2010)
bitbucket-25253 (7/28/2010)
Are the OPs getting bummer and dumber or just lazy and lazier
Yes.
There have been some really 'entertaining' questions lately. There have been some 'entertaining' replies too.
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
July 28, 2010 at 10:26 am
21. Common sense
22. knowledge
23. health
24. SQL Community
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
July 28, 2010 at 10:24 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
July 27, 2010 at 10:51 pm
Here are some resources for that
and
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
and
http://sqlserverpedia.com/blog/category/sql-server-performance-tuning/
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
July 27, 2010 at 6:18 pm
Have you considered loading the data into a temp table in mysql and then running a batch update in mysql through a stored procedure? If you do that then...
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
July 27, 2010 at 5:44 pm
Your welcome.
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
July 27, 2010 at 5:24 pm
You're welcome.
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
July 27, 2010 at 5:23 pm
No reason in a dev environment to leave the recovery model in full. Just switch to simple recovery.
And since your logs are growing substantially, you may want to find...
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
July 27, 2010 at 3:33 pm
You're welcome.
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
July 27, 2010 at 3:31 pm
Here is an article that also supports what Gail is saying.
This is by Paul Randal http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-(2930)-fixing-heap-fragmentation.aspx
Though he is talking about fixed fragmentation in heaps, the article applies (drop and 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
July 27, 2010 at 3:30 pm
Viewing 15 posts - 13,096 through 13,110 (of 19,560 total)