Viewing 15 posts - 2,341 through 2,355 (of 8,416 total)
shump66 (11/19/2010)
November 19, 2010 at 6:20 am
A better query plan is produced if you make the following small modification:
SELECT DISTINCT
attribute_id,
Val...
November 19, 2010 at 5:45 am
nageshp (11/19/2010)
Thanks for that I learnt new thing stuff function
You also learnt that SQL Server is the wrong place to format dates into strings.
November 19, 2010 at 5:25 am
QQ-485619 (11/18/2010)
How can I do to make the transcation commit every 10000 row.
There is a complete explanation and script in the following SSC article by Lynn Pettis:
http://www.sqlservercentral.com/articles/67898/
The article covers deleting...
November 19, 2010 at 5:23 am
GilaMonster (11/18/2010)
Jeff Moden (11/18/2010)
November 19, 2010 at 5:16 am
The CONVERT(varchar(4),YEAR(x0_0.DateEndedStandard) expression in the DateBegun column returns a type that is being implicitly converted without a style parameter. Lay the code out neatly and pay particular attention to...
November 19, 2010 at 4:56 am
All that said, until you can do the migration, these are my thoughts given the information provided so far:
1. My choice for unique clustered index would be (SchedDateTime, ID)....
November 19, 2010 at 4:40 am
jordantx (11/17/2010)
November 19, 2010 at 4:03 am
jordantx (11/18/2010)
November 19, 2010 at 3:42 am
Craig Farrell (11/19/2010)
November 19, 2010 at 2:32 am
Sumanta Roy (11/18/2010)
It is 64 bit system and running SQL server enterprise edition in cluster environment(45 node). Max. memory is not set. But I want the temporary solution now.
Set the...
November 19, 2010 at 12:39 am
Use a filtered unique index:
CREATE TABLE dbo.Appointments
(
patient_id ...
November 19, 2010 at 12:08 am
WayneS (11/17/2010)
I have some initial questions:--===== Get the rowcount - this is vital - it must not exceed the actual rowcount.
This seems wrong to me - surely the row count...
November 17, 2010 at 7:49 pm
mister.magoo (11/17/2010)
Now, the question is - does this make anyone happier about using it as you can define the sort order specifically?
No! Let me explain why:
The TOP is the...
November 17, 2010 at 7:39 pm
Viewing 15 posts - 2,341 through 2,355 (of 8,416 total)