Viewing 15 posts - 4,186 through 4,200 (of 5,685 total)
odeonkreel (2/1/2011)
I run a Full backup on all databases on my SQL 2008 Server. I do this once a week.My question is, should I be backing up the TransLogs too?
If...
February 1, 2011 at 4:15 pm
You can also get a double entry when there are two plans because of parallelism. One will parallel split, one won't.
February 1, 2011 at 4:14 pm
ron.richardson (2/1/2011)
He also mentioned that several of our databases were highly fragmented, but the...
February 1, 2011 at 3:55 pm
Iulian -207023 (2/1/2011)
I would evaluate the database with DBCC CHECKDB
... couldn't hurt...
and also shrink it with DBCC SHRINKFILE.
Um, why would you do that?
REINDEX, sure. Shrinkfile? That's...
February 1, 2011 at 3:50 pm
My understanding of the licensing, which admittedly has limitations, is that your failover target, and only that target, is the passive server.
So, if you have four servers, 3 active 1...
February 1, 2011 at 2:22 pm
Short answer: You don't. You borrow some long convoluted code off someone else, learn what it does to make sure you can fix it, and use that.
There's a number...
February 1, 2011 at 2:16 pm
npatel.bi (2/1/2011)
DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))When I run this query on 29th January it gaves me 10/01/2010.
When I run it right now on 02/01/2010 its giving me 11/01/2010.......
When...
February 1, 2011 at 1:46 pm
Brandie Tarvin (2/1/2011)
Craig, you've got me confused now. What part of that equation changes the days from the 1st to the 3rd?
The +2 part at the end. Here, look...
February 1, 2011 at 1:40 pm
Alright, so, some proof it's all about the data:
Using this as a test code:
SET NOCOUNT ON
IF OBJECT_ID( 'tempdb..#TestData') IS NOT NULL
DROP TABLE #TestData
IF OBJECT_ID( 'tempdb..#Tally') IS NOT NULL
DROP TABLE #Tally
--...
February 1, 2011 at 12:43 pm
Personally, I'd use an SSIS flatfile export and put in a calculated column with | to add at the tail. Then use ^ as your column separator.
February 1, 2011 at 12:13 pm
Removed invalid results due to mistake in cache anticipation. See next post.
February 1, 2011 at 11:32 am
Melanie Peterson (2/1/2011)
OK, that worked. Any idea why?And thank you!
Yes, because of conversion to different types and the defaulting of VARCHAR when you don't put numbers on it.
I modified...
February 1, 2011 at 10:36 am
Jeff Moden (2/1/2011)
Craig Farrell (1/31/2011)
I've got some significant error controls that need to occur so I need row by row tasking.
It's very odd to hear such a justification coming from...
February 1, 2011 at 10:26 am
Adam Blumenfeld (1/31/2011)
I'm just using Microsoft SQL Server Management Studio to import from an .xlsx file direction. If I have the import wizard create the table, it only creates the...
January 31, 2011 at 5:42 pm
Adam,
The 255 column limitation is due to MS Access. You should be able to directly connect SSIS to Excel and pull in all the Excel columns in a direct...
January 31, 2011 at 5:19 pm
Viewing 15 posts - 4,186 through 4,200 (of 5,685 total)