Viewing 15 posts - 286 through 300 (of 341 total)
It sounds like you just have too many FK's against your company table. At this point, the FK relationship should be maintained via code, and not via the internal...
The more you are prepared, the less you need it.
November 5, 2008 at 8:08 am
Have not yet done any setup with Windows Server 2008.
We do have SQL 2005 x64 on WS2003 x64. Works great.
The more you are prepared, the less you need it.
November 5, 2008 at 7:56 am
1) NO replication - it is not for disaster recovery / business continuity
2) Agree - first look at mirroring as part of the process. Hardware failure and other localized...
The more you are prepared, the less you need it.
November 5, 2008 at 7:54 am
I do not have the reference, but I do recall one one of the MS pages outlining that the backup file data, including the log information, had the same format,...
The more you are prepared, the less you need it.
November 5, 2008 at 7:49 am
Both approaches are viable, and under different circumstances could be considered the best approach.
If for example, you use a domain account for the login, the user login and pw are...
The more you are prepared, the less you need it.
November 5, 2008 at 7:47 am
The master database holds information that is specific to the local machine, and so trying to do a full master restore might not be a good idea.
As for the logins,...
The more you are prepared, the less you need it.
November 5, 2008 at 7:41 am
Another option would be to have the top level procedure call a function rather than a procedure. Functions can return not just single values, but also tables.
In the...
The more you are prepared, the less you need it.
November 5, 2008 at 7:35 am
Nice to know. I can see this as useful if you are building a proc that creates dynamically generated SQL. But dynamically generated code should be avoided if...
The more you are prepared, the less you need it.
November 5, 2008 at 7:31 am
Nice academic approach. No doubt I'll have to look this over a few times for it all to sink in.
The more you are prepared, the less you need it.
October 30, 2008 at 10:38 am
Normally I would agree, the optimizer tends to find the best path. But for this project we are running SQL2005 Standard Edition. As documented, with the exception of...
The more you are prepared, the less you need it.
October 30, 2008 at 6:27 am
I found the answer, but from what I can tell, it is a true bug.
Below is the proc code below. The fix is to comment out the WITH...
The more you are prepared, the less you need it.
October 29, 2008 at 1:46 pm
reposting in the SQL2005 forum.
The more you are prepared, the less you need it.
October 29, 2008 at 11:53 am
Nice job
The more you are prepared, the less you need it.
October 18, 2008 at 8:25 am
Super. then it must be some other isseus. Thanks
The more you are prepared, the less you need it.
September 25, 2008 at 9:21 am
Yes, it really gets down to understanding both the requirements and the tools.
I see many troubled/problem applications/systems where lack of storage knowledge was the biggest problem with the system. ...
The more you are prepared, the less you need it.
September 25, 2008 at 6:57 am
Viewing 15 posts - 286 through 300 (of 341 total)