Viewing 15 posts - 1 through 15 (of 15 total)
> "When issuing the DEFRAG C: -A-V command,, you get a lot of information, but you can not decide if it is good or bad.
MS are using percentage, but you...
August 16, 2005 at 1:04 pm
> "Suppose that the level of chaos (i.e. fragmentation) of the data in a given Data Base can be calculated and quantified. Such a factor will alert the System Manager...
August 16, 2005 at 9:30 am
Sql mail is not officially supported for MSDE.
August 1, 2005 at 10:24 am
".........Don't use write caching without a battery backup. Most caching controllers include a battery or offer one as an option. This battery retains data in the cache in...
July 28, 2005 at 1:04 pm
FWIW one might consider testing / implementing ECM for the DDL comparisons and something like Monarch for the data comparisons. HTH
July 28, 2005 at 12:39 pm
"Another is that it's a temp table, so the rules don't really apply. More than the first argument, I think there is some validity to this position. Not a lot,...
July 22, 2005 at 9:06 am
> Say you've got a 100g drive with a 40g database and for purposes of discussion the backup is also 40g, leaving you a cool 20g free. Add 10% to...
July 14, 2005 at 8:00 am
The logic describing the "fundamental problem" is fairly sound.
"This illustrates a major problem with SQL NULLS and the way they are used. There are essentially two reasons for missing...
June 28, 2005 at 10:29 am
"I also see the state/reason for missing data as a separate attribute from the data itself. That's why I believe it should be separated into its own column from the...
June 28, 2005 at 9:46 am
"To my mind there are far too many possible reasons that data could be missing to try to implement a separate 'NULL' type 'mark' for each situation, in the same...
June 28, 2005 at 6:11 am
> The MS SP's (it seems) have to be run in each DB separately and the information correlated.
Use Master
Go
Exec master..sp_HelpUser
Exec pubs..sp_HelpUser
Exec northwind..sp_HelpUser
January 13, 2005 at 8:50 am
...MS Supplies the following:
Exec sp_HelpLogins
Exec sp_HelpUser
Exec sp_HelProtect
Exec sp_HelpSrvRoleMember
Exec sp_HelpRoleMember
January 13, 2005 at 7:02 am
Implementing roles is very good advice; scripts that attempt to address the requirement are usually somewhat limited (especially if users may create database objects) Some procedures that may be of...
December 23, 2004 at 12:15 pm
RE: Q1 What is FCB for invalid file ID means?? Now to my problem. The following error I'm getting on my SQL Server machine. I tried to get the...
December 23, 2004 at 12:07 pm
RE: 1. why would executing an sp as simple as this (see below) cause a lock timeout? At any given time, there could be 20 or more requests to execute...
July 13, 2004 at 1:24 pm
Viewing 15 posts - 1 through 15 (of 15 total)