Viewing 15 posts - 19,291 through 19,305 (of 19,560 total)
Though the synonym solution may work, I would be concerned that the solution is not right - and may be a little more work and cost than you want /...
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 22, 2009 at 11:23 am
Gianluca Sartori (10/21/2009)
Jason, you forgot to mention:"put the pork chops in the launcher and aim to a clueless OP or wannabe DBA":-D
My apologies - 10,000 Hail DBAs
And certainly the wannabe...
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 21, 2009 at 10:58 am
Alvin Ramard (10/21/2009)
Kit G (10/21/2009)
GabyYYZ (10/21/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 21, 2009 at 10:18 am
We all have nightmare stories about developers and their code. Anybody have some stories about the accountant that thinks he's a DBA?
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 20, 2009 at 5:12 pm
I second the motion to create a "Whoop upside..." button
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 16, 2009 at 11:15 am
Looks like we have a String of hw questions
http://www.sqlservercentral.com/Forums/Topic736233-146-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
October 15, 2009 at 4:38 pm
Another thing that has worked for me when shrinking when there truly is free space - expand the file by a little bit and then run the command that Jeff...
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 4:36 pm
another alternative would be to use left(VEHDESC,41)
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 3:51 pm
I normally prefer application specific databases. I can also see the worth of having it in the same database. It depends on the needs, the application, the skill...
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 3:42 pm
If encrypted in the database it isn't stored in readable/understandable text in the database.
There could be encryption in place that is encrypting across the wire that is not database encryption...
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 11:06 am
In addition to failed jobs - you need to verify what jobs are running at the time the processor usage reaches 100%.
To find what is causing the problem it is...
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 10:00 am
Here is somewhere you could start
http://msdn.microsoft.com/en-us/library/ms179855(SQL.90).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
October 15, 2009 at 9:56 am
If I am catching this correctly,
You have a 270GB Data file that Had 7GB free prior to a truncate
Currently you have a 270GB Data file that still only has 7GB...
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 9:53 am
What have you done to try and troubleshoot?
Check jobs
sp_who2
blocking
long running queries
something outside of sql server consuming the processor
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 9:44 am
Two methods
dbcc checkident
and
Truncate Table
If you do a search on the checkident command you should be able to find the parameters and usage
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 9:42 am
Viewing 15 posts - 19,291 through 19,305 (of 19,560 total)