Viewing 15 posts - 4,576 through 4,590 (of 5,678 total)
SQL Iron Chef (12/13/2010)
In my environment I've seen:
1. WHERE ISNULL(burgertype, 'Bison Burger') <> 'Cheese Burger'
2. WHERE (burgertype IS NOT NULL OR burgertype <> 'Cheese Burger'
I'm just curious if there is...
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
December 13, 2010 at 1:39 pm
Alright, I'll bite. Anyone know how to turn a column from a stream in an SSIS package into a non-nullable version of itself? Data Conversion seemed like 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
December 13, 2010 at 1:22 pm
Renzo, you need to backtrack this to the source.
First, open up the raw document in something that can display CR/LF characters, like Notepad++. See if it's missing a LF...
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
December 13, 2010 at 1:16 pm
only4mithunc (12/13/2010)
Is it like declare @sql1 ,@sql2 etc as NVARCHAR(4000) , then finally @sql = @sql1+@sql2
sp_executesql @sql ... ?
You can keep doing it in a similar way, Only4. 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
December 13, 2010 at 1:12 pm
David...
1) GilaMonster = Gail Shaw. Definate she.
2)
Here my doubt is in this case as we are not able to use sp_executesql (due to the vary large length of 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
December 13, 2010 at 1:08 pm
GSquared (12/13/2010)
You won't be able to use a checksum on text.
Hmm. Guess I shoulda double checked the older format. It will work for VARCHAR(MAX), however. Yet another...
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
December 13, 2010 at 11:38 am
CELKO (12/13/2010)
Why is it a good idea to use proprietary...
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
December 13, 2010 at 11:32 am
Paul White NZ (12/13/2010)
Craig Farrell (12/13/2010)
As I'm wrapping my head around this, your comment above concerns me. This approach is as valid in 2k5 as well, right?
Yes :laugh:
All things...
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
December 13, 2010 at 11:14 am
Paul White NZ (12/13/2010)
LutzM (12/13/2010)
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
December 13, 2010 at 9:58 am
You might try ALTER DATABASE SINGLE_USER ROLLBACK IMMEDIATE.
This will force the database to a single_user mode (the one running the process) and rollback all transactions when it occurs. Make...
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
December 13, 2010 at 12:31 am
Tom.Thomson (12/12/2010)
GilaMonster (12/12/2010)
I wonder, if I change my avatar to a photo, will I stop having people call me Mr or Sir?
I guess it depends what it's a photo of....
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
December 13, 2010 at 12:24 am
Little Nick (12/12/2010)
tq sir. i'll try. will let you know if me facing any problem.
Please do. I'm sorry if you feel I'm being vague or sending you off to...
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
December 13, 2010 at 12:23 am
Offhand, there shouldn't be. That said, the merge join in SSIS tends to be a bit difficult the first few times you use it.
If you post your actual query,...
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
December 13, 2010 at 12:21 am
GilaMonster (12/12/2010)
I wonder, if I change my avatar to a photo, will I stop having people call me Mr or Sir?
And Peppermint Patty's friend Marcy will now be stuck in...
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
December 12, 2010 at 5:36 pm
ALZDBA (12/12/2010)
Steve Jones - SSC Editor (12/12/2010)
Tom.Thomson (12/12/2010)
Steve Jones - SSC Editor (12/11/2010)
Tom.Thomson (12/11/2010)
Celko's been at it again, and Gus's response http://www.sqlservercentral.com/Forums/FindPost1032150.aspx is unfair to monkeys.
Excellent response from Lowell and...
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
December 12, 2010 at 1:33 pm
Viewing 15 posts - 4,576 through 4,590 (of 5,678 total)