Viewing 15 posts - 12,991 through 13,005 (of 19,560 total)
Thanh Ngay Nguyen (8/5/2010)
Instead of using dbo.sysindexes, sys.partitions can be used to obtain the rowcount
SELECT ( SCHEMA_NAME(o.schema_id) + '.' + OBJECT_NAME(o.object_id) ) AS TblName,
...
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
August 5, 2010 at 2:38 pm
Don't forget rest and elevation. Lay down on a bed and elevate your head on a pillow.
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
August 5, 2010 at 2:22 pm
Jack Corbett (8/5/2010)
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
August 5, 2010 at 12:21 pm
I like the concept. I have a concern about usability in later versions of SQL server. The scripts should be updated to not use the deprecated system objects...
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
August 5, 2010 at 12:09 pm
Thanks Steve.
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
August 5, 2010 at 12:02 pm
Duplicate post.
Please post responses here:
http://www.sqlservercentral.com/Forums/Topic963922-147-1.aspx
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
August 5, 2010 at 12:01 pm
Alvin Ramard (8/5/2010)
Hey, we wouldn't age as far because our birthdays would only come every 1000 days instead of every 365 days. 😛
(10 day/week x 10 week/month x 10...
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
August 5, 2010 at 11:07 am
Greg Edwards-268690 (8/5/2010)
Defining a day, hours, and minutes - not so bad.
But then I started thinking...
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
August 5, 2010 at 11:03 am
Paul White NZ (8/5/2010)
Jack Corbett (8/5/2010)
Paul White NZ (8/5/2010)
I feel a blog entry coming on...
I was just thinking the same thing. I haven't had a truly technical post...
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
August 5, 2010 at 11:01 am
GilaMonster (8/5/2010)
CirquedeSQLeil (8/5/2010)
It also never fails that when you think the change is insignificant and decide to skip the backup part - something bad is going to happen.
Wasn't 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
August 5, 2010 at 12:23 am
GilaMonster (8/5/2010)
CirquedeSQLeil (8/5/2010)
I like to have a backup of the database right before I run the changes.Me too, but some people seem to want to live dangerously.
That's the kind of...
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
August 5, 2010 at 12:10 am
You don't have a backup of the database, but do you have a copy of it anywhere? For instance did you copy it to any other server for testing...
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
August 5, 2010 at 12:00 am
It doesn't go anywhere. This was a method for clearing out the log. It should not be used and it is being deprecated.
http://technet.microsoft.com/en-us/library/ms186865.aspx
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
August 4, 2010 at 11:53 pm
Thanks for the question. I had to search a bit harder for this one due to the options in the answers.
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
August 4, 2010 at 11:50 pm
I agree with Jack and Jeff. Do what is appropriate through stored procs and then use the GUI for what it does best.
Expressions oftentimes are very useful in SSRS...
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
August 4, 2010 at 11:31 pm
Viewing 15 posts - 12,991 through 13,005 (of 19,560 total)