Viewing 15 posts - 5,686 through 5,700 (of 7,484 total)
SQLkiwi (8/3/2011)
The parser handles the error thrown by evaluating 1/0 and stops trying to constant-fold that expression. As the 1/0 is nested inside...
August 3, 2011 at 10:58 am
LutzM (8/3/2011)
Tom.Thomson (8/3/2011)
Actually, if there were a world competition for the worst beers, no European country would come top - the worst European beers are comfortably outclassed for awfulness by...
August 3, 2011 at 10:34 am
petervdkerk (8/3/2011)
If you talk about the fact that I substituted campaignid=4 with campaignid=5, thats only because I was testing the code on another...
August 3, 2011 at 9:56 am
I used to go out and eat alone sometimes, go out and eat with colleagues some times, stay in and eat alone sometimes, stay in and eat with colleagues sometimes...
August 3, 2011 at 9:42 am
Carlo Romagnano (8/3/2011)
August 3, 2011 at 8:33 am
Great question, and the excellent comments from Paul make it even better.
August 3, 2011 at 8:31 am
Koen Verbeeck (8/3/2011)
LutzM (8/3/2011)
Koen Verbeeck (8/3/2011)
Not only excellent chocolate, also excellent beers 😉
And I do need the diapers, just not for myself 🙂
(I just found out I can order diapers...
August 3, 2011 at 6:10 am
hwells (8/2/2011)
The below produces the results I want but I'm sure there's a way to do this without hitting the table twice.
Presumably the actual table is very much larger than...
August 2, 2011 at 7:27 pm
petervdkerk (8/2/2011)
So you see, even though I (think I) narrowed it to canmpaignid=5, still the duplicate records from campaign 1 are removed from prospects, while these should actually remain intact.
I...
August 2, 2011 at 5:00 pm
Kenneth Fisher-475792 (8/2/2011)
August 2, 2011 at 4:17 pm
bitbucket-25253 (8/1/2011)
IGNORE THIS ENTRY SEE CORRECTION BY SQLkiwi Posted Today @ 4:23 AM
Regardless of Paul's correction, DBCC indexdefrag in SQL Server 2008 R2 appears to work on some...
August 2, 2011 at 4:02 pm
SQLkiwi (8/2/2011)
bitbucket-25253 (8/1/2011)
DBCC INDEXDEFRAG (Master,"dbo.spt_values",ix2_spt_values_nu_nc)DBCC INDEXDEFRAG (AdventureWorks_regular,"cdc.ddl_history",ddl_history_clustered_idx)-- a system table in the AdventureWorks_regular DB
Neither of those are system tables, they are ordinary tables that happen to be used by the...
August 2, 2011 at 3:13 pm
Kenneth Fisher-475792 (7/29/2011)
August 1, 2011 at 4:36 pm
GilaMonster (8/1/2011)
Here a telephone fault often takes a few weeks to sort out. I had a fault several years ago where I reported the line...
August 1, 2011 at 4:10 pm
george sibbald (8/1/2011)
........(and it wasn't their fault in the first place - some idiot developers had dug up a few metres of underground phone line). .
How do you know it...
August 1, 2011 at 3:56 pm
Viewing 15 posts - 5,686 through 5,700 (of 7,484 total)