Viewing 15 posts - 7,351 through 7,365 (of 19,560 total)
huff
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 30, 2011 at 8:10 am
please post the exact query you are using.
If it is saying it can't find the proc, try calling it with three part naming (db.schema.proc).
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 30, 2011 at 8:08 am
jeff.mason (12/30/2011)
If someone says that the registration date is more useful in their country and that this is an American-centric difficult question I will scream.
Well it did say that it...
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 30, 2011 at 8:01 am
bitbucket-25253 (12/29/2011)
HAPPY NEW YEAR
I second the motion.:-D:-D
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 29, 2011 at 10:41 pm
This query is fairly quick. If you need to know the success/failure of your jobs and you have that much history to comb, you will need to run a...
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 29, 2011 at 10:38 pm
Hopefully you will have the backups scheduled through an agent job. If you do, you can report on job history to find if a backup job completed successfully or...
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 29, 2011 at 10:24 pm
Can you provide the DDL for the personphone table?
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 29, 2011 at 8:29 pm
While running your backup across the network, get a netadmin to run wireshark and capture network activity between the host and network share. This is to try and rule...
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 29, 2011 at 7:34 pm
If adding the parenthesis as suggested is still not providing the accurate number of records, please post sample data and structures so we can recreate and test.
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 29, 2011 at 3:11 pm
It would only be applicable if the SQL service had been restarted.
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 29, 2011 at 2:50 pm
Here is a short tutorial how to get the query results via email.
http://jasonbrimhall.info/2011/08/15/send-dbmail/
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 29, 2011 at 2:38 pm
Jack Corbett (12/29/2011)
Stefan Krzywicki (12/29/2011)
Revenant (12/29/2011)
Stefan Krzywicki (12/29/2011)
Revenant (12/29/2011)
Brandie Tarvin (12/29/2011)
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 29, 2011 at 2:36 pm
crookj (12/29/2011)
SQLRNNR (12/29/2011)
crookj (12/29/2011)
Ray K (12/29/2011)
Evil Kraig F (12/29/2011)
crookj (12/29/2011)
WOTD - stodgyWaldorf (Muppets)
Statler
Flowers on the Wall
Brad Paisley
Smoking Cigarettes and Watching Captain Kangaroo.......
Thinking of country music, I thought of a different...
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 29, 2011 at 2:11 pm
crookj (12/29/2011)
Ray K (12/29/2011)
Evil Kraig F (12/29/2011)
crookj (12/29/2011)
WOTD - stodgyWaldorf (Muppets)
Statler
Flowers on the Wall
Brad Paisley
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 29, 2011 at 2:00 pm
I was about to suggest sentrigo - they have shown a bug in SQL that shows the SA password in clear text. But they are now a part 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
December 29, 2011 at 1:46 pm
Viewing 15 posts - 7,351 through 7,365 (of 19,560 total)