Viewing 15 posts - 4,186 through 4,200 (of 5,678 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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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
--...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 1, 2011 at 12:13 pm
Removed invalid results due to mistake in cache anticipation. See next post.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 31, 2011 at 5:19 pm
Viewing 15 posts - 4,186 through 4,200 (of 5,678 total)