Viewing 15 posts - 2,791 through 2,805 (of 14,953 total)
What data type is the column?
Does "1.0000" qualify as having a decimal point in it? Or does it need to have a non-zero value after the decimal to be...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 8:46 am
mister.magoo (11/19/2011)
BEGIN TRAN
-- Let's have a test table with an identity (to be forced out of order)
-- and a...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 8:44 am
p-nut (11/21/2011)
GSquared (11/21/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 8:31 am
You mean you don't just automatically do all of those things every day?
I have a job that runs them automatically every day, right in the middle of peak business hours,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 8:21 am
Koen Verbeeck (11/20/2011)
Sean Lange (11/18/2011)
Koen Verbeeck (11/18/2011)
That will only work if she keeps the lit on the pot, so that pressure rises within the pot.
I don't think you can increase...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 7:00 am
Here's a sample:
DECLARE @XML XML = '<values><Names First="GSquared" /></values>' ;
SET @XML.modify('delete /values/Names/@First') ;
SET @XML.modify('insert attribute xsi:nil {"true"} into (/values/Names)[1]') ;
SELECT @XML ;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 6:48 am
In that case, I'd start looking into using snapshots for the reports to operate off of. You're almost certainly on Enterprise Edition, which means that's a real option for...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 6:31 am
ChrisM@Work (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Hey guys I need your unbiased view of this....
Your impressions?
Move. Some of these fungi can cause serious respiratory problems. It's not worth taking the risk.
Second the motion.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 21, 2011 at 6:28 am
Instead of using the Microsoft wizard plans, I have a "DBA" database with configurable procedures in it, that manages all of that for me.
Much more granular control of the thing,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 18, 2011 at 1:45 pm
http://www.salary.com already has this data, plus a LOT more info. I haven't had trouble getting just SQL Server DBA data from it for the regions I've looked up.
Please always...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 18, 2011 at 1:39 pm
Do a join from TableA to the master table, then from that to TableB. Select Distinct on just the columns from TableA and TableB in that. That will...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 18, 2011 at 6:25 am
p-nut (11/17/2011)
GSquared (11/17/2011)
p-nut (11/17/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 18, 2011 at 6:11 am
It's pretty usual for queries of many sorts to run slower after a reboot, because of caching issues for both data and execution plans.
This sounds, however, like a good case...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 17, 2011 at 2:09 pm
If you pull all of them into a table variable, it will be faster than a temp table, because it avoid the distributed transaction coordinator. That will often give...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 17, 2011 at 2:07 pm
They are the same.
Better is a matter of opinion on this one. It doesn't really matter which you use, but be consistent with whichever you choose.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 17, 2011 at 2:04 pm
Viewing 15 posts - 2,791 through 2,805 (of 14,953 total)