Forum Replies Created
Viewing 15 posts - 12,871 through 12,885 (of 19,560 total)
-
RE: Best Practices on SQL Agent Job Frequency
yeek li (8/13/2010)
SQL Agent Job scheduler itself is very light, the minimal interval SQL Server supports natively is 1 minute. If you goal is to let you job response 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 -
RE: Are the posted questions getting worse?
bitbucket-25253 (8/13/2010)
Don't think I have seen this in the Thread, but today is Friday the 13 and we all know what that means.If memory serves me correctly it is 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 -
RE: Are the posted questions getting worse?
jcrawf02 (8/13/2010)
Alvin Ramard (8/12/2010)
CirquedeSQLeil (8/12/2010)
Should I have stopped at the value below?That's one hell of a beast!
I was just thinking it would have been funny as hell if everyone had...
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 -
RE: DATABASE ISSUE
balaji.ganga (8/13/2010)
Some of the unnecessary objects are available in our database.So that only i would delete those objects and shrink a database
Some of the objects are heap.There is no constraint....
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 -
RE: Finding Unique Non-Repeating Random Numbers
Thanks for the article Brandie
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 -
RE: How many users are too many?
it sounds like an application is probably using a common sql login for group authentication and then the "users" are stored in a table that controls permissions to the application....
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 -
RE: The Value of Blogging
Since I started blogging, I feel that I have gotten better at written communication. I also continue to strive to get better at it. I see room for...
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 -
RE: DATABASE ISSUE
balaji.ganga (8/13/2010)
What i feel is, Shall i do the below activities1. shrink a database
2. rebuild an index for all objects
3. update the statistics for all objects
Is it ok.. 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 -
RE: The Value of Blogging
WilliamD- (8/13/2010)
Somehow it is still difficult to do, especially when you read the blogs of people like you, or other prominent names in the field. I often get 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 -
RE: What Brand of Desktop is best these days?
Good point. I would probably still take my chances and be careful about purchases made. You could end up with a toshiba laptop after all and be without...
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 -
RE: Best Practices on SQL Agent Job Frequency
happycat59 (8/13/2010)
Personally, I would not implement this as a single task. Instead, I would do something like- create a file watcher process (VB.Net or C# can do this pretty...
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 -
RE: To change SQL Server 2008 Instance name
My understanding of those procedures is that they are for renaming a server not the instance.
Thus it would be like the following:
When you have more than one instance of SQL...
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 -
RE: DATABASE ISSUE
What have you done to try to find the issue?
Are you getting any error messages?
Are you getting deadlocks?
Are queries timing out?
Have you checked the index fragmentation?
Have you checked to ensure...
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 -
RE: What Brand of Desktop is best these days?
I would build it myself as well unless it was a laptop.
As for warranty issues and fixing issues yourself, I think that ship has long sailed with PC manufacturers 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 -
RE: SQL 6.5 and Y2K
I actually remember this one. Thanks for the question. Would you believe that there are still some installs of 6.5 out there in the world?
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
Viewing 15 posts - 12,871 through 12,885 (of 19,560 total)