Viewing 15 posts - 1 through 15 (of 31 total)
At my workplace, I have made our SQL Server DRs fairly trivial by scripting the DBMS installs, having standardized backup and restore procedures and a proc to generate all necessary...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
March 13, 2009 at 10:29 pm
Do you have any recomendations for a data dictionary tool? How to you keep up with allowable values for a specific column that does not have a reference table?
Well,...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
November 15, 2007 at 6:18 pm
A couple of other books I would highly recommend are The Data Modeling Handbook, by Reingruber and Gregory and Data Model Patterns by Hay. The first is an excellent...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
November 14, 2007 at 10:49 pm
That makes sense. I imagine the four that were fired happened before the msdb data files for that instance went offline. I guess its time to get MOM moved from testing...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2005 at 3:36 pm
I would be very careful in saying that a SAN should outperform an internal disk 99% of the time. I have worked at several sites where the number of fibre...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
August 19, 2005 at 5:43 pm
Correct me if I'm wrong here, but didn't you say that you have a number of unique keys on the same table? Does that not then imply multiple candidate keys...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
March 22, 2005 at 11:09 pm
This may be an issue with index maintenance during after each insert statement.
I ran your code as you gave it on against sql 7 and the inserts where finished in...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
February 15, 2005 at 11:57 pm
I have used both approaches and they both have there positives and negatives. The single table approach is great in keeping your databases from being populated with many code description...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
February 14, 2005 at 1:07 am
Did you try the sql I originally posted with the mods to change the age and remove the date predicate. i would have looked something like this:
SELECT CH1.Name
...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 9, 2004 at 9:06 am
If you are running multiple instances at Sp3a, you may have to get a hotfix from MS. We had that problem, which was not good because we use performance alerts...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 8:20 am
Lets look at your Question #2 a bit at a time.
The datediff("D",CH1.CallDate,getdate()) was used to come up with the "age" of the call. If that...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 7:23 am
hi,
Do you have a copy of MS's "Full-Text Search Deployment" white paper? ( found here http://support.microsoft.com/default.aspx?scid=kb;en-us;323739 
It says that you should either modify or...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 3:38 am
Did you look at :
http://support.microsoft.com/default.aspx?scid=kb;en-us;298794
http://support.microsoft.com/default.aspx?scid=kb;en-us;303459
Both refer to a specific registry setting.
from the latter:
This problem occurs frequently if the total size of all the catalog files exceeds 256...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 1:57 am
I'm not to sure how your "KISS" solution satisfies his requirement. I would be very interested to see you full SQL solution.
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 1:35 am
Well, if you are already using a DLL, you can change the architecture slightly to use a COM+ component to access the db. If you set the initial number of...
Ian Dundas
Senior IT Analyst - Database
Manitoba Public Insurance Corp.
December 3, 2004 at 1:23 am
Viewing 15 posts - 1 through 15 (of 31 total)