Viewing 15 posts - 47,851 through 47,865 (of 49,571 total)
Grab the datemonthstarts function from here[/url] and use that instead of MONTH.
Since you'll then be comparing datetimes, 1 Dec 2007 is < 1 Jan 2008
January 3, 2008 at 12:40 pm
Woot! :w00t: :w00t: :w00t: :w00t:
Congrats. It's most deservedly given.
So, where and when's the party?
January 3, 2008 at 6:05 am
MarkusB (1/3/2008)
Kevin is right about the IO messages which take too long, but in my experience these messages don't automatically lead to a stack dump.
They don't. The stack dump...
January 3, 2008 at 5:43 am
For completeness, and so no one gets the wrong idea about how to write triggers.
A trigger fires once for a statement. The inserted and/or deleted tables will contain as many...
January 3, 2008 at 5:36 am
Sharon Matyk (1/3/2008)
2) add a value which is the difference (in INT) between each row's date and the date on the row above.
This can be done with what I...
January 3, 2008 at 4:30 am
Yup. Pretty much. Just check what you need to audit. You don't want to do more than necessary. It shouldn't be necessary to og both the old and the new...
January 3, 2008 at 4:13 am
karthikeyan (1/3/2008)
select @Age = inserted.Age from inserted -- You can't use this table outside of trigger.
And what happens if I insert more than 1 row in a single statement?
-- How...
January 3, 2008 at 4:00 am
Some comments on that.
You have to check for an error after everty statement. @@Error only refers to the previous statement. If that ocmpleted succcessfully, then @@error = 0, otherwise it...
January 3, 2008 at 3:30 am
Good luck on the job hunt. 😉
I gave up on new years resolutions a while back but...
Brush up on C# skills
Spend more time on university work
And a couple others I...
January 3, 2008 at 3:12 am
When you use a variable in the where clause, the query optimiser cannot see the value of that cariable at the time the query is compiled and optimised. Since the...
January 3, 2008 at 12:16 am
Check that the tran log backups are running. How often do they run?
Run this query for the DB with the problem. Please post what it returns.
select name, recovery_model_desc, log_reuse_wait_desc from...
January 3, 2008 at 12:06 am
Is your database in full recovery mode?
Do you have transaction log backups occuring regularly?
Do you need to be able to resore this database to the moment of failure if something...
January 2, 2008 at 11:48 pm
Please don't cross post. It fragments replies and wastes people's time.
Any replies to below thread please
January 2, 2008 at 11:47 pm
Jeff Moden (1/2/2008)
Heh... for the same reasons, I do the very same thing. In fact, I incorporated that same method into the SQL Standards I wrote for work because...
January 2, 2008 at 11:40 pm
Not what I'm looking for. Dividing the number of rows by the page count will get the average number of rows per page.
What I'm trying to get is the...
January 2, 2008 at 11:22 pm
Viewing 15 posts - 47,851 through 47,865 (of 49,571 total)