Viewing 15 posts - 2,446 through 2,460 (of 19,560 total)
Markus (7/31/2014)
Gazareth (7/31/2014)
Markus (7/31/2014)
SQLRNNR (7/31/2014)
I'll try to think on it some more. I'm sure this odd error has you frustrated.
Yes. I've never seen anything like this before. ...
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 31, 2014 at 10:46 am
kanoodling
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 31, 2014 at 10:43 am
Account lockout for SQL Server is enforced by the local machine or domain policy in effect. This applies to SQL logins as well.
So if you want an account 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
July 31, 2014 at 10:42 am
Skip the Maintenance plan node and go straight down to SQL Server Agent. Expand that node. Right-click on the Jobs node and select New Job from the Context...
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 31, 2014 at 10:38 am
New Born DBA (7/31/2014)
Grant Fritchey (7/31/2014)
So, you're employer isn't likely to spring for a trip to Belgium then. Oh well. There's still Connections and PASS Summit.
Well we do have an...
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 31, 2014 at 10:31 am
crookj (7/31/2014)
Ed Wagner (7/31/2014)
BWFC (7/31/2014)
Revenant (7/30/2014)
SQLRNNR (7/30/2014)
Sean Lange (7/30/2014)
Ed Wagner (7/30/2014)
SQLRNNR (7/30/2014)
djj (7/30/2014)
whereisSQL? (7/30/2014)
Ed Wagner (7/30/2014)
TomThomson (7/30/2014)
SQLRNNR (7/30/2014)
Ed Wagner (7/30/2014)
Stuart Davies (7/30/2014)
SQLRNNR (7/29/2014)
aardvarkDigger
Hunting (for antiques)
Pecheur
é or ê?
Tomato
ketchup
hot dog
breakfast
Dinner
Bacon
Pork Belly
futures
Markets
Farmer
John
Doe
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 31, 2014 at 10:12 am
cdm33.com (7/31/2014)
Jason,
Thanks for your input. I'm looking at the last option where i script the checkdb for each database then. I'm hoping the script will not be long...
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 31, 2014 at 9:58 am
Sarah Wagner (7/31/2014)
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 31, 2014 at 9:32 am
I'll try to think on it some more. I'm sure this odd error has you frustrated.
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 31, 2014 at 8:37 am
The error being produced just smells of an issue trying to transfer data across the wire and that there is some sort of transfer issue.
Is the backend device attached via...
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 31, 2014 at 8:30 am
Thomas Abraham (7/31/2014)
Why would I use the method in the question when, as the answer showed, I can use:
SELECT *
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
I generally use sys.objects for this kind of lookup....
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 31, 2014 at 8:22 am
GilaMonster (7/31/2014)
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 31, 2014 at 8:16 am
It's very possible the manual and support have been trained on how to handle perf on MySQL as well and might be mis-interpreting it with MSSQL. They are, afterall,...
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 31, 2014 at 8:12 am
Grant Fritchey (7/31/2014)
cdm33.com (7/30/2014)
This code has hundreds of lines to it. I've got no clue what it does. I'm not going to put something like this on 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
July 31, 2014 at 8:09 am
I'm also a bit concerned that the table is 195GB with only 500 million records.
Could you run the script from here and paste the results for that table? 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
July 31, 2014 at 7:59 am
Viewing 15 posts - 2,446 through 2,460 (of 19,560 total)