Viewing 15 posts - 14,416 through 14,430 (of 59,063 total)
September 4, 2017 at 6:40 am
Check out sys.master_files. The data_space_id is the number for the filegroup. You'll also find a status in the "state" and "state_desc" columns. There is one entry for every file in...
September 3, 2017 at 7:27 pm
September 3, 2017 at 7:09 pm
rhythmk - Friday, August 11, 2017 11:22 PMHi,
I need to remove any punctuation characters at the end and before new line.
Please help.
Ok......
September 3, 2017 at 6:47 pm
Concerning the update code you posted...
1. Both tables need to use the 2 part naming convention of schemaname.tablename.(Small performance gain + data safety/integrity).
2. The "TKey" and "ProcessDate" column...
September 3, 2017 at 5:04 pm
Here is the...
September 3, 2017 at 3:44 pm
p.s. To save you some time, I've attached a file called "PerfMon.txt". After you upload it, change the name to "PerfMon.msc" and save it to the desktop of your server...
September 2, 2017 at 9:51 pm
Heh... I have a saying about designing databases... "If you think it was easy, you did something wrong". There are a lot of "standard" and "best practice" things that must...
September 2, 2017 at 12:48 pm
September 2, 2017 at 12:12 pm
September 2, 2017 at 12:03 pm
September 2, 2017 at 12:01 pm
September 2, 2017 at 11:55 am
September 2, 2017 at 11:45 am
Viewing 15 posts - 14,416 through 14,430 (of 59,063 total)