Viewing 15 posts - 19,501 through 19,515 (of 19,564 total)
Found this one very interesting. My initial understanding was that of logs having 8k pages. However - I think it comes down to as Steve said - trivia...
July 10, 2009 at 12:10 pm
If your log is full, is your disk full too?
What is the growth set to for your log?
What is your recovery model (full, simple)?
July 10, 2009 at 11:58 am
Another reason to have different instances would be (again along the security lines) to better segregate client databases. More politics, more administrative duties.
For your additional instance, is your cluster...
July 10, 2009 at 11:51 am
Though this is not my question, thanks Elliott for the answer. This will prove useful in my environment as well.
In addition to using TFS already.
July 10, 2009 at 11:42 am
You can create some procs that will take care of your reindexing needs. When creating the procs you can set them up as startup procs so they will run...
July 10, 2009 at 10:29 am
Nice article. This could prove very useful.
July 10, 2009 at 10:19 am
That should have done it for you. I have seen though that the freeprocindb sometimes doesn't clear it like we would want. Though all plans would be removed...
July 9, 2009 at 6:55 pm
Please provide us a sample query that might be using this structure (provide a sample of the schema too please).
Do you have clustered indexes on the underlying tables?
July 9, 2009 at 6:03 pm
If you were on sql2k5, I would suggest creating a ddl trigger to help monitor for this.
The DDL trigger in 2k5 can monitor for create, alter and drop events related...
July 9, 2009 at 5:48 pm
Select job type as cmdexec from within a new job / job step properties.
Give it a command such as :
DTSRun /S"Servername" /E /N"DTSPackageName"
It should be able to do it without...
July 9, 2009 at 5:38 pm
have you looked at the gui options?
tools - options - query execution - SQL Server - Advanced
and
tools - options - query execution - SQL Server - ANSII
July 9, 2009 at 4:31 pm
Good List by Michael. Excellent point by Jeff concerning the code review.
Review, review, and review some more the developer code.
I would like to throw in to the mix a...
July 9, 2009 at 1:18 pm
Maple data is better than honey data 🙂
Of the last two supplied queries, my preference would be for the first. That said, it would be best to do as...
July 9, 2009 at 11:15 am
I would definitely use the first two questions for an entry level type position.
Based on recent experience, we have encountered 50+ candidates who could not answer questions such as these....
July 9, 2009 at 11:09 am
Viewing 15 posts - 19,501 through 19,515 (of 19,564 total)