Viewing 15 posts - 16,411 through 16,425 (of 39,922 total)
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
You might look at some of these.
http://www.sqlservercentral.com/search/?q=restore+backup&t=s
April 20, 2011 at 10:22 am
Grant Fritchey (4/20/2011)
I can't comment on the kick-back program as it's currently configured. Suffice to say, if you've received a check, you earned it.
And if you've received a kick, you...
April 20, 2011 at 10:21 am
Can you define what is "slower"? Is it specific queries? Do you still have the old server and can you check specific items to see if they are really slower?
Gail...
April 20, 2011 at 10:17 am
Viewing 15 posts - 16,411 through 16,425 (of 39,922 total)