Viewing 15 posts - 1 through 15 (of 74 total)
The various "X in technology" groups also serve a function in making others aware of the legitimate differences between their group and others. This includes benefits the group may have...
David Lathrop
DBA
WA Dept of Health
March 31, 2014 at 3:36 pm
It's a good idea to check that the server_name column of msdb.dbo.backupset matches the server you are checking.
When you do a restore, if the backup set being restored isn't already...
David Lathrop
DBA
WA Dept of Health
April 22, 2013 at 12:17 pm
I aggree with opc.three.
As I said, we've just added MAXDOP=1 query hints when a query has failed at night more than once. It has only been a couple so far....
David Lathrop
DBA
WA Dept of Health
September 24, 2012 at 3:12 pm
I've wondered at the optimal setting also.
We have a problem with MAXDOP=0 in our environment. We are very lightly loaded at night, and only have a few large queries each...
David Lathrop
DBA
WA Dept of Health
September 24, 2012 at 12:56 pm
Without seeing the whole conditional, it's hard to tell if the ISNULL is a waste because NULL is not a value. E.g.,
WHERE ship_by_date > @today
OR ( pick_up_date IS NOT NULL
AND...
David Lathrop
DBA
WA Dept of Health
June 21, 2012 at 10:37 am
Answering the question asked in the original post, this could be a misunderstanding of the transaction and locking mechanisms in SQL Server.
If you are going to try pre-checking an...
David Lathrop
DBA
WA Dept of Health
June 21, 2012 at 12:16 am
Unfortunately, triggers won't work in this case; SQL Server doesn't have a "commit trigger" that would wait until a COMMIT to check the table for valid structure. Consider the following...
David Lathrop
DBA
WA Dept of Health
June 20, 2012 at 8:54 pm
Otherwise, the only thought I have, is that some of the tables could have been heaps, and now have forwarding records left in the un-emptyable file. If so, creating a...
David Lathrop
DBA
WA Dept of Health
June 20, 2012 at 8:30 pm
Without seeing the whole conditional, it's hard to tell if the ISNULL is a waste because NULL is not a value. E.g.,
WHERE ship_by_date > @today
OR ( ...
David Lathrop
DBA
WA Dept of Health
June 20, 2012 at 8:09 pm
You need to apply the appropriate tools and techniques for the problem at hand. Some major considerations are whether you are trying to integrate data from many disparate sources, is...
David Lathrop
DBA
WA Dept of Health
June 20, 2012 at 7:57 pm
If your database is heavily indexed, and you are rebuilding indexes frequently, this could account for the large log backups. This would especially be true if you have a small...
David Lathrop
DBA
WA Dept of Health
June 20, 2012 at 7:27 pm
I thought the question was poorly phrased. I guessed that it was essentially "Full Model requires log backups to guarantee a point in time restore to any moment throughout the...
David Lathrop
DBA
WA Dept of Health
February 21, 2012 at 3:22 pm
I'm not sure if this is the correct answer; I've got the same lack of "server status" display on half of our servers, but haven't had time to pursue it...
David Lathrop
DBA
WA Dept of Health
September 8, 2011 at 10:31 am
It sounds like you should be using package configurations.
First, I would set up a standard set of package-level variables with the same naming convention in each package. These will be...
David Lathrop
DBA
WA Dept of Health
April 7, 2011 at 11:14 am
jts_2003 (11/23/2010)
What interested me was how long the random names are in sysobjects - obviously Microsoft planning for LOTS of temporary objects being created!
It's not the number of names, it's...
David Lathrop
DBA
WA Dept of Health
November 23, 2010 at 7:02 pm
Viewing 15 posts - 1 through 15 (of 74 total)