Viewing 15 posts - 1,081 through 1,095 (of 1,132 total)
Not if you known the thruput capabilities of the disk sub-system, which is almost never known.
Personnaly, I never bother with Disk Reads/sec or Disk Writes/sec but only collect "%Disk Time",...
May 19, 2005 at 9:11 am
From the SQL Server Books on Line: Read the sentances regarding "Storage size"
To navigate directly to this subject, open BOL and from the menu select "go" then "url" and...
May 18, 2005 at 10:10 am
The license information is in the registry, here is a .reg for a 2 CPU license:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\MSSQLLicenseInfo\MSSQL8.00]
"FlipAllow"=dword:00000000
"ConcurrentLimit"=dword:00000002
"DisplayName"="SQL Server 2000"
"FamilyDisplayName"="Microsoft SQL Server"
"Mode"=dword:00000002
May 17, 2005 at 4:33 pm
Try this:
SELECT fun.function_desc
, fun.function_code
FROM table_1 fun
join(select itm.function_code
from table_2 itm
JOIN table_3 par
ON par.parameter_code= itm.parameter_code
WHERE par.class_code = 1
group by itm.function_code
having count(*) = 1
) as P ( function_code )
on ...
May 17, 2005 at 9:28 am
What is the version of SQL Server including the build number?
"after many updates after rebuid at saturday" - Did you run a index optimization after the updates?
May 17, 2005 at 9:18 am
The "Local Packages" folder list those packages that are saved in the local SQL Server (in the msdb database).
Package that are in file systems are never listed under any of...
May 15, 2005 at 7:14 am
This is a very complicated subject but has been explained in full by SQL Server MVP Erland Sommarskog in two article named "Error Handling in SQL Server – a Background"...
May 13, 2005 at 4:30 pm
SQL Server Enterprise Manager is a snap-in under the Microsoft Management Console (MMC). MMC snap-ins have a msc extention. The SQL Server Enterprise Manager snap-in is usually at "C:\Program Files\Microsoft...
May 12, 2005 at 4:11 pm
Extended procedure xp_logininfo can supply the members of a Windows Group. For Windows Groups within Windows Groups, you will need to write some recursive SQL (while loop) to get the...
May 11, 2005 at 4:03 pm
Is the server very busy ? These may be a time-out for the OS when the space allocation cannot be completed within a reasonable amount of time. The...
May 8, 2005 at 12:25 pm
As an alternative, consisder using the Data Transformation Services's Transform Data Task with the fast load option combined with setting the database to use the BULK_LOGGED recovery option. From...
May 6, 2005 at 10:45 am
Are you aware that for a SQL statement that includes an UDF, Profilier and Statistics on event SQL:BatchCompleted do NOT include the resoures used by the UDF?
Here is an example...
May 6, 2005 at 10:13 am
If this message from a database or transaction log backup and you are backing up to disk on a different server, then on both servers, check the NIC card configuration...
May 6, 2005 at 9:06 am
You may be having rounding occuring as 128 is an integer. Intead, divide by 128.0 which is a decimal.
select name , size sizePages
, size * 8 as SizeKb
, (size...
May 2, 2005 at 10:36 am
Viewing 15 posts - 1,081 through 1,095 (of 1,132 total)