Viewing 15 posts - 19,306 through 19,320 (of 19,560 total)
krypto69 (10/15/2009)
I was told my predecessor had configured encryption, but all the data I have seen in all the databases..none of that is encrypted..
Wouldn't...
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
October 15, 2009 at 8:20 am
Charip,
First Logging would have to be enabled. Do you know if you have logging enabled?
Here is a whitepaper on the subject provided by our friends at Microsoft.
http://msdn.microsoft.com/en-us/library/ms138020.aspx
You could also...
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
October 14, 2009 at 7:49 pm
I am curious why you need to use sql server to stop this service. I am also curious what service is being stopped and what is being restored.
These are...
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
October 14, 2009 at 4:25 pm
Grant Fritchey (10/14/2009)
Bob Hovious 24601 (10/14/2009)
"You'll have to get the rest of your question answered by someone else... they're about to close the casket, and nobody bothered to put...
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
October 14, 2009 at 3:24 pm
jcrawf02 (10/14/2009)
Bob Hovious:
We're developing code in the T-SQL forums, it's not like a hospital emergency room .
This made me laugh, as I have a sneaking suspicion that some 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
October 14, 2009 at 2:57 pm
I would assume this is for audit purposes. You might be able to satisfy him by demonstrating that the data is encrypted in the database (via certificate or otherwise)....
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
October 14, 2009 at 1:55 pm
Since this was side by side, are those the current file stats for the 2000 instance?
Did you by chance perform a Reindex operation on the 2000 Instance while the file...
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
October 14, 2009 at 1:50 pm
GSquared (10/14/2009)
s ss (10/14/2009)
GilaMonster (10/14/2009)
s ss (10/14/2009)
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
October 14, 2009 at 1:40 pm
db_bunny (10/14/2009)
Is there any equivalent DMV for monitoring object access of other types, such as how often certain stored proc's are executed? And if not, what is a good...
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
October 14, 2009 at 9:32 am
This is as I figured. I could think of no sound reason for this type of setup. When I checked the original creation script for this table, both 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
October 14, 2009 at 9:18 am
Been there, done that with kids (i have 4). I don't know which part is more exhausting - the driving or the kids who never get tired and are...
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
October 13, 2009 at 8:07 pm
How dare you cross the girls and not get your swimsuit.
Tell them you'll get a kilt instead:)
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
October 13, 2009 at 7:54 pm
Are the sql services running for that instance?
Is the domain account locked or expired - or did the password change recently?
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
October 13, 2009 at 5:22 pm
Is your SQL box 64 bit?
If so, try this:
Install the Oracle ODAC (available on the Oracle Technology Network) and a patch (#5043675 available on Metalink) that fixes a bug that...
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
October 13, 2009 at 12:41 pm
What is your disk configuration?
What additional indexes do you have?
How long does it take to do:
Select Count(id) from yourtable
I think that beyond normalization, an exercise in re-defining the data dictionary...
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
October 13, 2009 at 12:23 pm
Viewing 15 posts - 19,306 through 19,320 (of 19,560 total)