Viewing 15 posts - 37,321 through 37,335 (of 39,720 total)
Generally they are not indexed. The underlying table indexes are used. If you do choose to index a view, then it builds this index and takes overhead to update it...
July 24, 2002 at 1:54 pm
Items like stored procedure work against the object_id for the table, not the name. If recompiled, they will fix the dependencies.
Steve Jones
July 24, 2002 at 1:48 pm
Show off your vast knowledge in areas that have no relation to the contract. Like football!
Steve Jones
July 24, 2002 at 1:47 pm
Only way I know is to load each and read the header. Probanly can use DMO to do this.
Andy?
Steve Jones
July 24, 2002 at 1:44 pm
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
Viewing 15 posts - 37,321 through 37,335 (of 39,720 total)