Bob Fazio (10/26/2007)

---

Nice blog Grant!

1) If it is too slow to be useful -> then you need to tune it more 🙂

2) If no one is complaining, then it...

Hi Ed,

It's been a long time. Hope you are doing well 😀

http://support.microsoft.com/kb/Q240872

Here is the relevant part:

Download the MapSids.exe file, and then extract the Sp_sidmap.sql and Readme.txt files.

3.Log on to the server that is running SQL Server as a system administrator, and...

EXCEPT for distribution 😉

passwords in 2000 setup with "default settings" are case insensitive.

Are you trying to solve a series of exam questions ?

Login Triggers

Are these a series of "exam" questions ?

😀

Reindexing, Update statistics (WITH FULLSCAN) and DBCC UPDATEUSAGE come to mind.

At some later point you may (or may not ) want to perform a DATA_PURITY check too 😉

nachikethm@yahoo.com (10/23/2007)

---

Hi,

I have got situation like that presently my huge table contains around 54 millions records and on daily basis it is increasing by around 75k/day.

I have got sever performance...

Especially with Large Backup files; is a BAD idea to use a network share 😉

This a little "simpler 😉

CREATE TABLE #tmp (EmpID INT , LocationID INT , Amount NUMERIC(9,2))

INSERT #tmp

SELECT 1, 1, 15.00 UNION ALL

...

Details are important if you want a decent answer. Please, Help us help you 😉

sp_helpdistpublisher

If the databases are on the Same server I would use "SYNONIMS" instead.