Viewing 15 posts - 46 through 60 (of 114 total)
I think all you can do is set your recovery model to bulk logged and try to proactively prevent fragmentation.
(Those operations are eligible for minimal logging.)
Sorry
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
January 11, 2011 at 5:16 pm
This is very similar, if not identical to a sql challenge posted a while back. check out the discussion related to it, I think you'll find some good tips:
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 2, 2010 at 2:52 pm
a) Hire an intern or use rentacoder to retype it.
b) copy the content into textpad, and write a regular expression find and replace to put create before table, etc.
c) use...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 2, 2010 at 12:04 pm
I think what you're looking for is:
;WITH recGroups AS (
SELECT DeviceEsn,
Location,
recTime,
MIN(RecTime) OVER (PARTITION BY DeviceEsn) as minRecTime,
MAX(RecTime) OVER (PARTITION BY DeviceEsn) as maxRecTime
FROM #IdTable
WHERE IdNumber = 1
)
SELECT mn.deviceEsn,
mn.location AS enterLocation,
mx.location...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 2, 2010 at 11:35 am
IN IE, the default behavior is to hide the true error. You'll get better information if you go to "internet options" in the tools menu, click on the advanced...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 2, 2010 at 10:39 am
I agree with GSquared. Actually, this is a case where I would make very sure that the actual business requirement is the same as what you have on paper....
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
December 1, 2010 at 12:02 pm
I think more clarification is required...
Are you looking for help writing code to generate your triggers or are you looking for how to write the triggers themselves?
If it's the triggers,...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 30, 2010 at 12:02 pm
One point: Celko's noticed that your grouping set is almost assured to be distinct, so the max(id) for each set should be the max for the table. This seems...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
November 30, 2010 at 11:37 am
The SQLCat team has published a top 10 list of best practices for building-a-large-scale-relational-data-warehouse in which they recommend against checking foreign keys on large fact tables. (recommendation 4, last point)
They...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
October 21, 2010 at 1:09 pm
Pete,
No, by approximate, it is not meant that no finite numbers are representable, for example 1, .9, .1, and .005 are representable just fine. It is just an acknowledgment...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
August 26, 2010 at 10:42 am
you have to love when the system is designed in such a way that you can guess the correct answer without knowing anything just by which name makes sense... ...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
August 19, 2010 at 12:26 pm
Noone can answer this question as-is.
check out http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
August 5, 2010 at 9:02 am
Probably have more luck in the administration forum.
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
August 5, 2010 at 8:57 am
Unfortunately in SSRS 2005 this is not an option. You can set the formatting of many of the elements, but you cannot format parts of a single element differently.
If...
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
August 5, 2010 at 8:54 am
You can also use the same data source for both the default and available values.
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
August 5, 2010 at 8:46 am
Viewing 15 posts - 46 through 60 (of 114 total)