Viewing 15 posts - 34,666 through 34,680 (of 39,903 total)
Not sure what the criteria is, but I've used underscores with no issues. Tried running it all together, no separators?
October 13, 2004 at 10:51 am
http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp
Links to the other 3 parts.
October 13, 2004 at 10:49 am
If 8000 users access the servers, you'd license on a per seat basis and license 8000 users. The CAL is by user, not workstation or app.
If you have significantly less...
October 13, 2004 at 10:46 am
Beware that the values are not necessarily unqiue. If you delete a partial range and reset the identity values, then you may or may not overwrite other values. Also, if...
October 13, 2004 at 10:45 am
What do you mean calculate performance?
October 13, 2004 at 10:44 am
Not sure what you mean here. Are you looking for information on reading execution plans?
October 13, 2004 at 10:42 am
Briscoe is correct, so I will award the points back. Also I will correct the question to say "numeric".
Steve
October 12, 2004 at 12:48 pm
You cannot take a backup that includes only tables and I'm not sure what you are trying to do? Are you looking to make periodic backups? Is your app going...
October 12, 2004 at 10:40 am
Joe,
What do you mean disable? Are you trying to test a restore of Master?
October 12, 2004 at 10:39 am
I would assume you'd join the TOrderDetail to the TOrder based on the OrderID column.
October 12, 2004 at 10:38 am
These are hard to track down. The query plan is built based on conditions on the server at the time it's compiled. Have you checked to be sure the indexes...
October 12, 2004 at 10:37 am
Not sure about the buffer size. Haven't worked with it. The batch size, however, can prevent the logs from filling. It tells the package what size of (Rows) to insert...
October 12, 2004 at 10:36 am
Most likely it will continue for the next 5-6 years. SQL Server 7 is still supported (although that's about to end) and it was released on 99.
October 12, 2004 at 10:34 am
What does the process do? Perhaps the data has changed. Be sure you run update statistics on the tables involved, also check dbcc showcontig for fragmentation. If it's drastically changed,...
October 12, 2004 at 10:33 am
If you have a steady enough workload, i.e., not too many ad hoc queries, then this will work. It typically hasn't been an issue with my systems, but we have...
October 12, 2004 at 10:32 am
Viewing 15 posts - 34,666 through 34,680 (of 39,903 total)