Viewing 15 posts - 1,801 through 1,815 (of 6,216 total)
Are you sure it worked before? That is way outside the upper bound for an int, which is 2,147,483,648.
Andy
August 10, 2003 at 7:36 am
I dont think so, though you can do it with triggers and a linked server if nothing else. There is at least one 3rd party product (whose name escapes me...
August 6, 2003 at 2:44 pm
I'd use the TSQL:SQL:StmtCompletedEvent, for columns you want textdata, duration, reads, writes. Probably apply a filter to limit it to the database you're checking. How you get the Top 10...
August 6, 2003 at 2:43 pm
Profiler has some options for grouping, but the best/easiest way is to just capture all the sql statements, then throw into a table where you can analyze any way you...
August 6, 2003 at 1:48 pm
DMO is the right tool for scriping. I've done a few DMO articles over the last couple years with lots of different examples:
http://www.sqlservercentral.com/columnists/awarren/allarticles.asp
Andy
August 6, 2003 at 1:45 pm
You might need to increase the timeout on the logreader. Rebuilding requires a lot of log entries and the reader has to process all of them even though they don't...
August 6, 2003 at 1:43 pm
Mark, if you have time I'd be interested in an article that covers how you got it all working. Contact me directly if interested.
Andy
August 6, 2003 at 7:00 am
We dont use UDT's either. The abstraction is nice, but change is painful. I'll admit that UDT's shouldnt be changing, but sometimes they do. So far not managing scripts in...
August 6, 2003 at 6:58 am
Im assuming that the missing ";" between the statements is a typo?
Andy
August 5, 2003 at 6:19 am
Im not advocating less spindles, just more space. Remember that disks get slower as they get fuller and that you'll probably want to back up to disk. Cache does offset...
August 5, 2003 at 6:16 am
I think it makes more sense to do it on the client. Procs arent especially good at string handling, Access is.
Why wouldnt you normalize the relationship and store each genre...
August 5, 2003 at 6:13 am
Cant zip because? The latest revs of PKZip/Winzip support greater than 4g zip sizes. If you just dont have space to do it, you can just copy it across.
Andy
August 4, 2003 at 4:48 pm
Direct attach is cheaper, but I've got an EMC SAN and very happy with it. Its hard to compare apples to apples, the cache on the SAN really makes the...
August 4, 2003 at 4:46 pm
Put the code in a trigger. If you really want this type of auditing you dont want it in client code where it could be bypassed.
Andy
August 4, 2003 at 4:39 pm
Found a ref that says its nothing to worry about:
What does the log say? Its possible that the system was still in recovery and thats why you got the timeout....
August 4, 2003 at 4:37 pm
Viewing 15 posts - 1,801 through 1,815 (of 6,216 total)