Viewing 15 posts - 39,451 through 39,465 (of 49,571 total)
Tao Klerks (4/28/2009)
April 28, 2009 at 7:50 am
Tao Klerks (4/28/2009)
Interesting approach - we use Convert, relying on the fact that DateTime values are internally stored as floating-point values, with every whole number representing a day:
Just be careful...
April 28, 2009 at 7:46 am
Tao Klerks (4/28/2009)
April 28, 2009 at 7:41 am
What about Change Tracking? (not the same as Change Data Capture) It's available on all editions.
April 28, 2009 at 7:39 am
Paul White (4/28/2009)
Would that not work then? :laugh:
It'll work, that ain't the point
The latest suggestion in the date-time to date precision discussion, is to store the date part in a...
April 28, 2009 at 7:34 am
April 28, 2009 at 7:28 am
Kurt W. Zimmerman (4/28/2009)
April 28, 2009 at 7:27 am
Tao Klerks (4/28/2009)
April 28, 2009 at 7:22 am
Grant Fritchey (4/28/2009)
SELECT * FROM TEST101
WHERE CODE=105 AND ACNO=14000
ORDER BY CODE
--WHY IT IS GOING FOR CLUSTRED INDEX OF COLUMN "ID"
--Now it is going for non clustered index, this is...
April 28, 2009 at 7:21 am
Paul White (4/28/2009)
On a separate subject, can I ask: Are articles checked or reviewed before publication on SSC?
There's no technical review done, if that's what you're asking. Firstly Steve's vision...
April 28, 2009 at 7:11 am
johny (4/28/2009)
Yes. The records that end with '9' take more time every time.
Can you post output of statistics IO and Statistics time?
April 28, 2009 at 7:08 am
Schadenfreude-Mei (4/28/2009)
We are thinking of putting in a log shrink after the backup, but i wanted to check that this was also going to be replicated to the mirror.
Why,...
April 28, 2009 at 6:55 am
Simon Smith (4/28/2009)
For example the concept of locking seems to have bypassed them and locking whole tables whilst reporting is common.
*twitch* Ouch
I could do without the hassle of setting...
April 28, 2009 at 3:12 am
From Books Online:
Use the remote query timeout option to specify how long, in seconds, a remote operation can take before Microsoft SQL Server times out. The default is 600, which...
April 28, 2009 at 3:10 am
mithun.gite (4/27/2009)
SELECT * FROM TEST101--WHY IT IS GOING FOR CLUSTERED INDEX OF COLUMN "ID"?
Because there's no filter of any form. That query reads the entire table, hence the only way...
April 28, 2009 at 2:58 am
Viewing 15 posts - 39,451 through 39,465 (of 49,571 total)