Viewing 15 posts - 37,546 through 37,560 (of 39,941 total)
Space (log and data) are always good. You might want deadlocks. Not sure I'd set many more without intending to watch for a specific problem.
Steve Jones
July 24, 2002 at 1:32 pm
dbcc showcontig shows fragmentation on tables.
Steve Jones
July 24, 2002 at 1:30 pm
SQL 2000?
You should be ok on the inserts. Is this 1M in a time frame? Per Day isn't too bad unless it's 500k one hour and 500k over 11...
July 24, 2002 at 10:39 am
Andy has the best suggestion. EM doesn't have a way.
Steve Jones
July 24, 2002 at 10:32 am
Great reference item. Nice to know some of these are available.
Steve Jones
July 24, 2002 at 10:07 am
SQLMail will ONLY work with MAPI or SMTP.
Check out the Resource page:http://www.sqlservercentral.com/resourcecenter/sqlmail.asp
Steve Jones
July 24, 2002 at 10:03 am
EM uses 1433 and 445 to connect and check services. Be sure this passes the firewall.
Also, you can increase the timeout in the Tools menu.
Steve Jones
July 24, 2002 at 10:02 am
select distinct firstname
, lastname
from table b
If you need to remove duplicates, then you want a subquery that basically matches up the minimum...
July 24, 2002 at 10:01 am
Save as a .dts file (use the "save as"). Then you can script this as a dtsrun item to run.
Steve Jones
July 23, 2002 at 4:38 pm
None I know of. Be intersted to see if there is.
Steve Jones
July 23, 2002 at 4:36 pm
Set a constraint. Same size, less scale.
Steve Jones
July 23, 2002 at 4:35 pm
Has to do with the severity and the errors. Some cannot proceed with processing. Which errors are cuasing issues?
Steve Jones
July 23, 2002 at 4:33 pm
pause maybe? Can you connect with EM and check?
Steve Jones
July 23, 2002 at 4:32 pm
To get a list of tables, columns, etc. More stable than sysobjects, syscolumns, etc which might change.
If you wanted to update all columns named "MyID" with a default, you could...
July 23, 2002 at 4:30 pm
a)Get a copy of Inside SQL Server, it will explain this complicated topic in detail.
b)yes
c)not really fragmentation to me, but an intersting idea. Not something you can do anything about...
July 23, 2002 at 4:26 pm
Viewing 15 posts - 37,546 through 37,560 (of 39,941 total)