Viewing 15 posts - 9,241 through 9,255 (of 59,078 total)
You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will...
May 20, 2019 at 6:48 pm
If you don't use the tools correctly, then there is probably not much chance you are working correctly without them either, I guess.
The problem is that a whole lot...
May 20, 2019 at 3:06 pm
If I'm reading you correctly, I totally agree. SWITCH is a great reason to partition. That's not the "performance" thing that most folks talk about and that I tend to...
May 20, 2019 at 2:07 pm
That pretty much supports what I've found. It's actually people finally paying attention to the data and doing some decent indexing that makes the code run faster. Because they're finally...
May 20, 2019 at 1:52 pm
And posting powerpoint slides is kinda worthless if one subscribes to the belief that powerpoint should supplement the presentation, not contain the presentation.
I subscribe to "It Depends". If it's...
May 20, 2019 at 12:26 pm
Then, restore all the main BAK and all the existing TRN files to the new server but make sure that ALL of those restores, including the last one, ALL use...
May 20, 2019 at 12:21 pm
Hold the phone a minute. Have you determined WHY the NDF files exist? If they're associated with partitioning, you absolutely DO NOT WANT TO MAKE THEM THE SAME SIZE. It...
May 20, 2019 at 12:14 pm
What is msdb.dbo.agent_datetime? There is no such table in my environment.
It's the function MS built into the system to convert the integer dates and times that are listed in...
May 20, 2019 at 12:03 pm
Soooo.... it wasn't actually the partitioning but column store that made the improvement?
May 20, 2019 at 12:00 pm
You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will actually take...
May 20, 2019 at 11:53 am
I have mixed reactions when it come to 3rd party tools. They're a great thing to have but I find they make people a fair bit lazy about learning unless...
May 20, 2019 at 2:52 am
Since this is a huge subject and you don't yet know the lay of the land, see the following. You should read it (especially about the migration assistant) even before...
May 19, 2019 at 3:13 pm
I may be an exception because of my limited use of partitioning (couple of serious tests for a couple of forum posts a long time ago and a 1TB call...
May 19, 2019 at 2:56 pm
Considering that you posted this in the SQL Server 7/2000 forum and you clearly state that you're using 2014 and an SSIS package (and SSIS didn't even exist in 7/2000),...
May 19, 2019 at 2:12 pm
Yes. Use a column that has the IDENTITY property and, if you need to know what value the IDENTITY proper assigned during an INSERT of a new row, use the...
May 19, 2019 at 1:33 pm
Viewing 15 posts - 9,241 through 9,255 (of 59,078 total)