Viewing 15 posts - 3,511 through 3,525 (of 7,429 total)
Oh and after an change the one key step no matter if success, failure or success after issue is
Do a group follow up and make a list of lessons learned.
For...
January 22, 2003 at 4:10 am
sorry should have included
exec
not really too much they can do without that as far as keywords go and sp_executesql is covered by
sp_
I am sure there are some others...
January 22, 2003 at 3:56 am
Are you using Terminal Services perhaps?
January 22, 2003 at 3:50 am
I previously posted code for this as an idea but cannot find it and of course cannot find a save here.
Basicall it was having an SP that took the entire...
January 21, 2003 at 4:25 pm
Sorry it doesn't do anything cool like that. I believe it is sampling the move for verification and closing the connections.
January 21, 2003 at 4:12 pm
quote:
But Antares, by rebuilding the indexes actually you are rebuilding the stats as well. So the update stat should not really necessairly...
January 21, 2003 at 4:10 pm
Actually it is an extra 4 bytes for the row header. Plus 2 bytes for the variable length column count in the row. Plus with a single nvarchar 2 bytes...
January 21, 2003 at 3:59 pm
As long as you have the proper client drivers and rights on the tables you can.
January 21, 2003 at 2:56 pm
DOes IssueField exist in one of the tables already (1 or 2). If so then you are doing the WHERE condition on that field not your resulting field. Instead you...
January 21, 2003 at 2:55 pm
quote:
I'm a bit confused by those replies.David - If the system has to be up and running when it's needed, then is...
January 21, 2003 at 11:52 am
Try casting into a value where the numbers can be larger such as numeric.
SELECT cast( as numeric(28,0))*cast(8192 as numeric(28,0))/cast(1048576 as numeric(28,0))AS SizeMB FROM sysfiles
January 21, 2003 at 10:10 am
This is my weekly routine for cleanup on tables with around 5-10 million records. Do in off peak so no one sees it happen (don't know if you have an...
January 21, 2003 at 8:56 am
I have done 3 installs and not come across anything. However there is a thread on this site that is discussing having issues with the install. Just make sure you...
January 21, 2003 at 7:42 am
Are all the hardware pieces the same? Type and speed of NIC, Amount of RAM, type, speed and access time of HD, etc? Many hardware aspects can affect overall performance...
January 21, 2003 at 7:30 am
Take a look here http://www.sqlservercentral.com/scripts/contributions/603.asp
January 21, 2003 at 5:19 am
Viewing 15 posts - 3,511 through 3,525 (of 7,429 total)