Viewing 15 posts - 6,901 through 6,915 (of 14,953 total)
CirquedeSQLeil (3/16/2010)
When people start congregating, I tell them I will let them know what the status is with regular email updates. Then I crank up the music 😀
This works...
March 16, 2010 at 11:52 am
Paul White (3/16/2010)
jcrawf02 (3/16/2010)
Paul White (3/15/2010)
In fact it is as bad as DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP), 0).All right Paul, edumacate me. Why is this bad?
Zero is not a date any...
March 16, 2010 at 11:39 am
Why the complexity?
The SessionID is used to group 2 to 30 people who attended the same meeting e.g The attendee will have a ServiceID(PK), Date, Time, Meeting Room, Speaker, NmbrAttending,...
March 16, 2010 at 11:34 am
Here's a query that seems to do what you need. Try it, let me know if it works.
Performance on it will be a problem, but I can't fine tune...
March 16, 2010 at 8:35 am
The insert scripts need single-quotes around the dates, otherwise it treats them as math problems. "08/01/2010" = 8 divided by 1 divided by 2010 = 0 (because it's integer...
March 16, 2010 at 8:19 am
There might be a way to do that in the report, but why not just handle it in the query? That would be much easier.
March 16, 2010 at 8:14 am
Take a look at DDL triggers in BOL. They can capture create, grant, deny and other events. Very useful and pretty easy to set up.
March 16, 2010 at 7:22 am
Merge replication is for when you have separate copies of parts of the database, so it won't work here for what you need.
I'd definitely look into the Merge command for...
March 16, 2010 at 7:14 am
Just to chime in, great article.
This kind of thing is why performance tuning isn't "one and done", but is an ongoing battle. Good illustration on that.
March 16, 2010 at 7:11 am
Yep.
Or, to put more explictly: I agree with the editorial. Far too often, I've seen people react to stress by doing stupid things.
On the other hand, after you've had...
March 16, 2010 at 6:46 am
Jeff, it's c. 60M rows per month, because of the prefix. That's probably enough for most business purposes (unless you're Amazon, Google, et al).
Totally agree with the rest of...
March 16, 2010 at 6:42 am
Turn the aggregation query into either a correlated subquery or a CTE, then use that for your update command.
March 16, 2010 at 6:37 am
I'm not familiar enough with the mobile version of SQL Server to really point you in the right direction on this.
What I'd do if it were Express on a laptop...
March 16, 2010 at 6:35 am
irozenberg (3/15/2010)
GSquared (3/15/2010)
Steve Jones - Editor (3/15/2010)
March 16, 2010 at 6:19 am
Roy Ernest (3/15/2010)
people born on 29th of February never gets old... 🙂 They are always young..
If you divide age by 4 for them, then they have to be 72 actual...
March 15, 2010 at 3:30 pm
Viewing 15 posts - 6,901 through 6,915 (of 14,953 total)