Viewing 15 posts - 1,591 through 1,605 (of 5,678 total)
I recommend you read through Gail Shaw's blog on catch-all queries, you can find it here:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
April 29, 2012 at 5:34 pm
Jeff Moden (4/29/2012)
Nope... not the way I meant it. For the first and second optimizations, you would limit the lat/lons to the following yellow square.
D'oh, okay, now I getcha....
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
April 29, 2012 at 2:55 pm
GilaMonster (4/29/2012)
Tara-1044200 (4/29/2012)
I am getting the errorMsg 536, Level 16, State 5, Line 1
Invalid length parameter passed to the SUBSTRING function.
Because you're trying to remove more characters than the string...
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
April 29, 2012 at 2:21 pm
Bob Barrows (4/29/2012)
There's still one...
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
April 29, 2012 at 1:23 pm
adc22 (4/29/2012)
@craig-2: Actually a new Project is on the way. So just preparing in advance. 🙂
One more related question .. can 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
April 29, 2012 at 1:22 pm
Jeff Moden (4/29/2012)
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
April 29, 2012 at 1:20 pm
Jeff (and OP) if I read this problem correctly, he doesn't have an endpoint yet and is trying to find said endpoint. Also using that technique you could miss...
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
April 29, 2012 at 12:52 pm
Tara-1044200 (4/29/2012)
i am just trying s simple select stmt 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
April 29, 2012 at 12:45 pm
adc22 (4/29/2012)
I have some questions regarding SQL server 2008. Below situations are from DB testing arena .
1) How to check a trigger is fired or not, while doing database...
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
April 29, 2012 at 12:43 pm
SQL Saturday out here in Phoenix was a lot of fun, and of particular interest I met a LOT of good people, including finally getting a chance to meet our...
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
April 29, 2012 at 11:19 am
I have a similar problem, partially because I'm a contractor who does whatever comes along, partially because I've never dedicated in one direction or the other.
I keep two resumes. ...
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
April 27, 2012 at 12:52 pm
So two things.
1) Who's heading to SQL Saturday in Phoenix? I know Steve's going and I'm looking forward to meeting him, any other threadizens? Oh, warning: I don'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
April 27, 2012 at 12:48 pm
From a distribution and load sharing perspective, apparently MySQL blows MS SQL Server out of the water, at least according to a few dual admins I know and one 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
April 27, 2012 at 12:32 pm
Dynamic SQL is the only way to alter your target 'on the fly'.
In a case like this however you might be better off just setting up a massive union 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
April 25, 2012 at 4:57 pm
A few things.
1) Restart Visual Studio/BIDs. the cache occassionally gets wonky.
2) Go through the package and look for OLEDB sources that are using stored procedures and the like. ...
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
April 25, 2012 at 3:59 pm
Viewing 15 posts - 1,591 through 1,605 (of 5,678 total)