Viewing 15 posts - 27,091 through 27,105 (of 39,768 total)
Yep, agree with Paul. A web app backed by SQL Server is an example of multiplexing.
September 11, 2008 at 10:36 am
Gail's series, GRant's book, Craig Freedman's blog. all good places to learn about this.
As Gail says, time and place for everything.
September 11, 2008 at 9:22 am
Likely you need a combination of datepart (turns date into numbers) and then possibly a CAST.
September 11, 2008 at 9:18 am
You are multiplexing here. This is the same as a web server talking to users and only talking to SQL. Still the users are using SQL Server indirectly through a...
September 11, 2008 at 9:17 am
Jack is correct. The diff stores changes SINCE the full. So it doesn't have a baseline on which to work. A diff is used to reduce the number of log...
September 11, 2008 at 9:08 am
It is what it said. You likely created the trigger with different SET settings than the table.
Change ANSI_PADDING, redo the trigger and then it should be OK.
September 11, 2008 at 9:06 am
My bet is a lot of what will come out of this is how to collect, manage, store, and anlalyze a tremendous amount of data.
September 11, 2008 at 9:06 am
You would use an UPDATE statement to change the data.
update tableB
set tableB.col = a.col
from tableA a
where TableB.othercol = a.othercol
The query syntax you have for SELECT would be...
September 11, 2008 at 9:04 am
There is no way you can get any level of code done that you're sure does this for US$395. Even at the cheapest rates you'd use way more than that...
September 11, 2008 at 9:01 am
Search for "cross tab" as well. That's what this is.
September 11, 2008 at 8:58 am
This looks like it will prevent deleting ONLY if there is a value of "1" in the Locked field. The row isn't necessarily locked.
also, this is an INSTEAD of trigger,...
September 11, 2008 at 8:57 am
Is there a restore operation occurring? It could be in STANDBY, which would allow read connections to it. You would need to remove those connections. Either tell people to disconnect...
September 11, 2008 at 8:54 am
I think it's a transient error. I know I got notified of a PM yesterday in email.
You can delete PMs, so the link isn't guaranteed to work. You can click...
September 11, 2008 at 8:47 am
Jim
Agree with you there. I was surprised to learn this, but I also wouldn't want my instance stopping because of tracing. The data is lost, perhaps there should be some...
September 11, 2008 at 8:45 am
An out-loud chuckle was heard in the office this morning. Very nice story!
September 11, 2008 at 8:31 am
Viewing 15 posts - 27,091 through 27,105 (of 39,768 total)