Viewing 15 posts - 5,071 through 5,085 (of 19,560 total)
You can use the following:
http://jasonbrimhall.info/2013/01/07/ssrs-subscriptions-report/
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 4, 2013 at 4:12 pm
Yup. I always did the detach in 2005 after a bad experience. But yup - the syntax is supported in 2005. I don't recall the specifics 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
February 4, 2013 at 3:42 pm
Besides the baseline, I prefer the method of looking at the big picture as was mentioned in the article. I prefer to avoid fixing the symptom when a bigger...
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 4, 2013 at 2:56 pm
george sibbald (2/4/2013)
ALTER DATABASE yourdb
(
NAME = logicalfilename,
FILENAME = N'c:\t1dat2.mdf' --for example
);
then offline 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
February 4, 2013 at 2:37 pm
You can load the plan into SQL Sentry Plan explorer. It is a lot more user friendly.
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 4, 2013 at 2:23 pm
anthony.green (1/29/2013)
SSRS Diagnostic Reports - http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/Deploy it to your SSRS report manager then use the Report Queries report.
Nice Info
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 4, 2013 at 2:19 pm
You can leave the extension off if you wish. I wouldn't recommend it but it does work.
To rename it, detach perform the file rename and then reattach is what...
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 4, 2013 at 2:07 pm
I typically just go for sys.objects like the following.
SELECT SCHEMA_NAME(schema_id) As SchemaName
,name As TableName
FROM sys.objects
WHERE type = 'U'
An interesting sidebar on this is that if you look 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 4, 2013 at 2:04 pm
Jysafe Lerroy (2/4/2013)
We just recently started using Avamar to backup everything including an hourly SQL server transaction log backup. The issue we’re having is that since we started using Avamar,...
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 4, 2013 at 1:56 pm
Lynn Pettis (2/3/2013)
Whoo Hooo! DTA to the rescue!!
SWEEEEET
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 4, 2013 at 12:44 pm
Sean Lange (2/4/2013)
Do you have any applications that use this database? If so, look at the connection string. 😛If not, wouldn't it be easier to just uninstall and reinstall?
Particularly 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
February 4, 2013 at 12:39 pm
crookj (2/4/2013)
Daniel Bowlin (2/4/2013)
SQLRNNR (2/4/2013)
bcsims 90437 (2/1/2013)
sing4you (2/1/2013)
ToastMelty Peanut butter....Yum
NUTELLA - nuf said
mmmmmmmm
On Celery.....
On more nutella
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 4, 2013 at 12:34 pm
Here is one possible solution
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 4, 2013 at 12:08 pm
Koen Verbeeck (2/1/2013)
Easy one (thanks Itzik! :-)) to end the week. Thanks!
+1
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 4, 2013 at 11:45 am
bitbucket-25253 (1/30/2013)
Thanks for a clear, concise QOD .. and good to be reminded of the basics,
+1
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 4, 2013 at 11:44 am
Viewing 15 posts - 5,071 through 5,085 (of 19,560 total)