Topics
Started by
Posts
Last post
Hi all, Where can I find the difference between FIleSystem and MSDB for storing the SSIS packages. …
14 replies
I would like to install sql server 2005 on a new server. what usually is the best storage and arran…
19 replies
Hi ALL, I have a table with say columns A,B,C,D,E,F,G,H,I. My Problem is that I have many indexes o…
17 replies
Hi All, I also noticed one interesting thing here In the Maintenance Plan. When I specify BAK in th…
2 replies
I can't disable a login that is in one of my DB's. I only see the disable if the login is under 'se…
1 replies
I'm trying to categorize which databases on my database server are the most utilized for the purpos…
5 replies
Is there any way to figure out the host machine name from where an sql trace was originated or some…
2 replies
Hello, Quick question about ALLOW_PAGE_LOCKS. Should I set this to ON for all indexes in a heavy tr…
12 replies
what are the main purposes for which temporary tables are used? I want to know the uses of tempora…
25 replies
Dear All, First i install sql server 2005 standard edition, after that i upgrade it by sql server 2…
2 replies
I'm analysing some of the IO stats on a SQL 2005 Server and some of the columns returned by fn_virt…
1 replies
I have an odd issue with connection to 2 SQL 2005 instances. Each exist on a different cluster. F…
9 replies
We're going to move our 8 tempdb data files to separate luns. I thought I could create all of them …
2 replies
Hi, There is an interview question that the SQL Server 2005 database is slow. What will you do to f…
9 replies
declare @rc int declare @TraceID int declare @maxfilesize bigint declare @filecount int set @maxfi…
5 replies
Viewing 15 topics - 4,756 through 4,770 (of 22,780 total)
You must be logged in to create new topics.