Viewing 15 posts - 3,136 through 3,150 (of 18,926 total)
4 TB in 1 table?
Missed the period! 🙂
August 22, 2011 at 11:17 am
tx.
Only 7K stas to drop. Yes I said 7K.
😀
I'll need to analyze this a little further!
August 22, 2011 at 11:16 am
I don't see anything for column b here?
Loner (8/22/2011)
The bigint actually is a time field (millisecond) calculating from 1970/01/01.
The where clause of the main...
August 22, 2011 at 11:12 am
GilaMonster (8/22/2011)
Are you absolutely sure it's a table? Because there's no join at all in that procedure, it's valid for SQL 2005/2008.
+1
Or maybe a synonym?
Trigger is my default answer to...
August 22, 2011 at 11:06 am
On the base table(s).
An indexed views materialize the results of the view and must be kept up to data every time you do dml on the base table(s).
And it's a...
August 22, 2011 at 11:03 am
Grant Fritchey (8/22/2011)
No, an hour seems very excessive for that query.
I just did a speed test on my prod server.
Everyone's out to lunch and we have a very decent san.
It...
August 22, 2011 at 10:58 am
SKYBVI (8/22/2011)
when i execute that query on my server, it saysUser doesn't have permission to run htt query
Why does it tell so when i already logged in as sa??
Some...
August 22, 2011 at 10:53 am
SELECT COUNT (*) FROM (
select MclId from vDCRDoctordetails
where LocationId=121 and month(DcrDate)=4 and year(DcrDate)=2011
and UserId=121 group by MclId having count(MCLId)=1
) dtGrpBy
August 22, 2011 at 10:38 am
I'd still like a demo script if you have one laying around :Whistling:
August 22, 2011 at 10:32 am
SELECT * FROM dbo.sysobjects WHERE XType IN ('PK', 'UQ')
Please note that there's a difference between unique constraint and unique index. UI won't be in the objects table.
Re-edit 18K 🙂
August 22, 2011 at 10:29 am
GilaMonster (8/22/2011)
Ninja's_RGR'us (8/22/2011)
Let's say that you run update stats but the distribution didn't really change, nor the min / max values.Do you still get a plan recompile at next run?
Yes.
Getting...
August 22, 2011 at 10:27 am
GilaMonster (8/22/2011)
Ninja's_RGR'us (8/22/2011)
GilaMonster (8/22/2011)
Ninja's_RGR'us (8/22/2011)
P.S. when something runs 10X slower than something else, the plan is NOT the same... or should not be the same.
Unless there's major blocking/waits on the...
August 22, 2011 at 10:25 am
So you got the next E = MC2 blatantly visible in your query (not the output, just the query)?
I've never seen a query so special that it couldn't not be...
August 22, 2011 at 10:23 am
Viewing 15 posts - 3,136 through 3,150 (of 18,926 total)