Viewing 15 posts - 16,456 through 16,470 (of 39,970 total)
You don't get anything. The question was written in fun a few months back and most people in the US see Apr 15 as tax day. It was extended this...
April 20, 2011 at 1:47 pm
A few things. First, you cannot use SET inside a SELECT. If this code is going to handle one insert at a time, you would move to an IF statement.
DECLARE...
April 20, 2011 at 1:42 pm
That data sent by the client can be spoofed. You cannot count on those values in sysprocesses as they are provided by the client. There is no authentication here.
If you...
April 20, 2011 at 11:57 am
You're not making sense here. How does the counter for c increase by 1 when the counter for c increases by 100? Doesn't flow.
Is everything based on column a?
If there's...
April 20, 2011 at 11:24 am
I tried a dozen or so of the formats, and none of them will convert 13:10 (in a datetime) to 1:10.
The only solutions I've seen were to convert to char,...
April 20, 2011 at 11:15 am
Check the alert, and see what it is configured for. This ought to be under SQL Agent in Enterprise Manager.
As far as limiting memory, Jack is correct. You need to...
April 20, 2011 at 11:14 am
What do you mean with client_host? do you mean the host name sent through the connection? That's completely arbitrary. It defaults to the windows host, but someone can fake that....
April 20, 2011 at 11:05 am
I'd also reboot and try it again. If you downloaded the media or burned it, double check this isn't a corrupt file by installing on another machine
April 20, 2011 at 11:03 am
Look at Target Server Memory for each instance. This is what each SQL instance would like to have. Chances are it will be high, but you might get a proportional...
April 20, 2011 at 11:03 am
I haven't heard of any good ones. It's a hard problem to solve visually and most vendors have avoided it.
April 20, 2011 at 11:00 am
the storage format isn't really important. The display is what is important. Display formatting is separate from how the data is stored.
AFAIK, you will have to convert this hours to...
April 20, 2011 at 10:59 am
First, always back up locally. this ought to be scheduled and not a big deal.
If you are looking to transfer them to a central location, that's a copy function. Across...
April 20, 2011 at 10:53 am
What I'd recommend is that you shrink it a little, perhaps 25GB, then the do an index rebuild. So schedule those operations together, in that order.
Once that's done, check free...
April 20, 2011 at 10:50 am
The problem with multi-connect scripts is that they sometimes fail and blow up. What I might look to do is have each server execute the query and store the results...
April 20, 2011 at 10:49 am
It will work, but this isn't a great way to store and query this data. You ought to look at refactoring this over time and storing those "slots" in another...
April 20, 2011 at 10:36 am
Viewing 15 posts - 16,456 through 16,470 (of 39,970 total)