Viewing 15 posts - 2,971 through 2,985 (of 5,678 total)
GilaMonster (6/16/2011)
Go watch this:http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/DPR201
TechEd North America presentation titled "The Architect". Fantastic and so funny in so many places
Well spoken and funny, and dead on target. Thanks for the link....
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
June 16, 2011 at 5:59 pm
See the first link in my signature for what CC's asking for. Help us help you, we don't want to have to build our own sample testbeds to show...
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
June 16, 2011 at 4:28 pm
Brandie Tarvin (6/16/2011)
But the OP is having issues with SQL Express 2008.
Just re-went through the thread and we're on the 2k5 forum... where am I not seeing the version? ...
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
June 16, 2011 at 3:34 pm
jcrawf02 (6/16/2011)
GSquared (6/16/2011)
My dog chased a squirrel up my pants-leg one time.I'll take wild rodents over arachnids any day of the week.
One might kill me, but the other is pretty...
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
June 16, 2011 at 12:52 pm
I'm getting a similar issue through my own testing.
Slap together a quickie Test DB somewhere and drop this table build into it:
CREATE TABLE CheckpointTest
(ctID INT IDENTITY( 1, 1) NOT NULL,
ctSomeData...
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
June 16, 2011 at 12:49 pm
Ninja's_RGR'us (6/15/2011)
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
June 15, 2011 at 4:21 pm
Um...
SELECT COUNT(*) FROM Tbl WHERE LEN(field) - LEN( REPLACE(field, ' ', '')) = 2 AND field not like '%[0-9]%'
? That seems too easy.
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
June 15, 2011 at 4:18 pm
I'm sorry officer, my sanity shot him before I could talk it out of saving itself...
Alright, start with a LEN(field) - LEN( REPLACE(field, ' ', '')) = 2
That'll locate your...
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
June 15, 2011 at 3:04 pm
Wait... then... who the heck is responding to me on the 1k+ posters board?
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
June 15, 2011 at 2:58 pm
quillis131 (6/15/2011)
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
June 15, 2011 at 1:13 pm
lfernandesfotos (6/15/2011)
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
June 15, 2011 at 1:10 pm
GilaMonster (6/15/2011)
Craig Farrell (6/15/2011)
lfernandesfotos (6/14/2011)
The analysis is interesting, however, can make life difficult for developers that use the database.
Developers should be going through procs anyway. I can hand you...
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
June 15, 2011 at 11:50 am
quillis131 (6/15/2011)
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
June 15, 2011 at 11:10 am
lfernandesfotos (6/14/2011)
The analysis is interesting, however, can make life difficult for developers that use the database.
Developers should be going through procs anyway. I can hand you a four hundred...
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
June 15, 2011 at 11:04 am
allmhuran (6/14/2011)
Craig Farrell (6/14/2011)
Some Bit vs. Bitmap testing.That was unexpected. Thanks for posting this.
My pleasure, I personally was a little shocked myself on the newer engines. I'd thought...
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
June 15, 2011 at 11:01 am
Viewing 15 posts - 2,971 through 2,985 (of 5,678 total)