Viewing 15 posts - 46 through 60 (of 97 total)
Yeah, this is a recurring problem. The problem is the rack is physically full!! Be a month or so for the new rack. This is a very large...
July 15, 2008 at 9:24 am
I would verify the physical disks are of the same speed and also check the IO throughput on each disk. Maybe some physical differences there. Is the IO...
July 15, 2008 at 9:22 am
XML is pure evil in the data tier. I don care if XPATH make my job 1000% easier to wade through 500k xml blobs. A realtional engine should not...
July 15, 2008 at 9:15 am
What is your current backup strategy? The answer to this will help us give you an answer that will not danger your data retention. Also what type of environment is...
July 15, 2008 at 9:01 am
Pretty sure that in 64 os the mem cons from task manager falls in the category of bogus.
July 12, 2008 at 5:13 pm
I would get the fire and sword out and demand another tier do this work. My tier CPU is allocated to set based operations. not gross string sex. I...
July 11, 2008 at 9:46 pm
If your really concenred about it, schemas could help you to create some groupings. Also check out SQL 2005 partioning, much improved over 2000 and can come in handy in...
July 11, 2008 at 9:44 pm
Better suggestion, make the app do length check and take the appopriate action.
July 11, 2008 at 9:39 pm
Issues can also occur when * is used and new attributes are added to the entity. Best case it only adds confusion in the middle tier, worst case data gets...
July 11, 2008 at 9:29 pm
Thank you for the practical real world article. But.....
xp_cmdshell is on the same path as xp_fixeddrives and may be removed. This is a major security risk and needs to be...
February 21, 2008 at 7:32 pm
Sorry this was a bad example. This was some example code and would never be appropriate to identity a user.
From the app side, I was thinking the savings would incur...
February 18, 2008 at 9:31 am
Yes its there. I guess the question is around the handling of the exception when the constraint check fails.
February 17, 2008 at 11:11 pm
EdVassie suggestion works fine. You may have a problem with a few of the auto run files(at least i did). I simply deleted these files as they are not needed...
February 11, 2008 at 11:48 am
This could also be called job security.
February 11, 2008 at 11:45 am
Great article. As others have mentioned we are pessimistic here in SQL Serverville. We must always be very cautious of locking. I like to pass that decision on the...
January 31, 2008 at 10:00 pm
Viewing 15 posts - 46 through 60 (of 97 total)