Viewing 15 posts - 5,221 through 5,235 (of 5,678 total)
Jeffrey Williams-493691 (10/25/2010)
You have a simple mistake in your test:
SELECT key1, key2 FROM #tmp
EXCEPT
SELECT key1, key2 FROM #tmp2
Sadly, that wasn't a mistake, that's actually what I'm trying to do, 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
October 25, 2010 at 8:16 pm
Is this a new development or has the system been slowly stagnating over time?
If it's a new development, and it's a cluster, force a failover. Let the users work...
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
October 25, 2010 at 8:10 pm
I recently ran into this one head first.
The view using ROW_NUMBER() has to compute all the rownumbers before the where clause from the outer call gets involved.
So SELECT * 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
October 25, 2010 at 5:45 pm
WayneS (10/21/2010)
Here is the latest version of the Delimited Split Function
DelimitedSplit8k... d'oh. My bad. Thank you Wayne. It's now (finally) stored in my 'favorites' folder.
Jeff and yourself...
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
October 22, 2010 at 4:46 pm
Alvin Ramard (10/22/2010)
Craig Farrell (10/22/2010)
Alvin Ramard (10/22/2010)
Alvin Ramard (10/22/2010)
I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how...
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
October 22, 2010 at 4:01 pm
Alvin Ramard (10/22/2010)
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
I...
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
October 22, 2010 at 3:37 pm
Can't... resist...
after the deployment of ssis package in filesystem.
we run the package in filesystem in ssms.
commonly run the package in dtexeutility.
after we are providing the roles to the client.
how 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
October 22, 2010 at 3:31 pm
Alvin Ramard (10/22/2010)
[rant]I'm getting sick and tired of having to deal with people trying to use SSIS without taking the time to learn how to use it first!!!!!!!!
[/rant]
Heh, DTS 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
October 22, 2010 at 1:50 pm
Brandie Tarvin (10/22/2010)
GilaMonster
I love this reply from one of the regulars over at SQLTeamHave a look at your post and then think about if we can understand what you want...
Hey,...
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
October 22, 2010 at 12:17 pm
dcohn99 (10/21/2010)
Thank youI cannot take the Raid off the OS. The server is in a data center so instant physical access is not happening.
Well, that sucks.
We are 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
October 22, 2010 at 12:09 pm
Here's the DelimitedString8k function that's been heavily worked on round these parts. Modify to suit your needs. I didn't create it, didn't work on it, and have copy/pasta'd...
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
October 21, 2010 at 6:00 pm
WayneS (10/21/2010)
Craig Farrell (10/21/2010)
Going up to the SAN on Monday morning just before everyone starts needing to crank out work and hotswapping one drive in every RAID 5...
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
October 21, 2010 at 5:44 pm
Alvin Ramard (10/21/2010)
Stefan Krzywicki (10/21/2010)
Q: Explain how to determine if a table has a primary key?Lock the database, if the table can get back in, it has a key.
That's not...
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
October 21, 2010 at 5:40 pm
Ahhh, Cheap fun...
Going up to the SAN on Monday morning just before everyone starts needing to crank out work and hotswapping one drive in every RAID 5 array... just 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
October 21, 2010 at 5:18 pm
You'll really want to get logs and tempdb off the same physical spindles if possible. There will be some heavy contention there if you don't.
By preference, data/logs are on...
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
October 21, 2010 at 5:06 pm
Viewing 15 posts - 5,221 through 5,235 (of 5,678 total)