|
Rebuild Indexes on SQL 2005 RG (nobody(a)nowhere.com) writes: When you choose not to "sort results in tempdb", where are the sort results being stored? Books Online says: The intermediate sort results are stored in the same database as the index. When you choose, to "sort results in tempdb", it appears that tempdb log... 21 Mar 2010 15:05
SQL 2005 Performance We have a win2003 domain with two win2003 servers that host a large SQL 2005 database. For some time we (users/sys admin) have been very disapointed in the performance of the database whichs uses a client-server setup for healthcare records. I am a system admin for the hospital. This week we are running a "str... 21 Mar 2010 18:36
Rebuild Indexes on SQL 2005 When you choose not to "sort results in tempdb", where are the sort results being stored? When you choose, to "sort results in tempdb", it appears that tempdb log file is growing endlessly. The sql server is 24x7 and can't restart it any time. I tried truncating the log and that didn't work. Is thre a way ... 21 Mar 2010 10:30
Logfile per Trigger Hallo, Newsgroup, ich will mit einem trigger überwachen, ob in einer Tabelle Änderungen vorgenommen wurden.Mit "FOR inserte, update" bekomme ich die Änderungen in eine separate DB-Tabelle geschrieben. Aber wie komme ich an die deleted? Mein Problem ist, dass ich nicht ausschließlich auf die deleted-Tabelle zugre... 21 Mar 2010 08:19
Replicating from SQL 2000 to SQL 2008 I have 2 instance of SQL Servers. Instance A : SQL Server 2000 Enterprise Edition running on Windows 2003 (32 Bit). Instance B : SQL Server 2008 Enterprise Edition running on Windows 2008 (64 Bit Cluster). These servers both reside on different domains but have connectivity between them using SQL Authentication... 21 Mar 2010 23:16
Management Studio - Local servers do not appear in the list of local servers I have both a named instance of SQL Server 2008 and Express 2008 installed. When I try to connect with Management Studio, neither of those instances appears in the list of local servers. But I can see them in the list of network servers. In Local, I can see Integration Services only. Under the Network Servers t... 21 Mar 2010 06:06
Figuring sql server version via code Hi Is it possible to check in .net; 1. If sql server 2008 express is installed on a machine? 2. The name of sql server 2008 express instance or instances? 3. If a particular sql server 2008 express instance contains a specific database? Many Thanks Regards ... 20 Mar 2010 21:05
Is There a Slicker Way? I have a table of free promotions. Each promotion begins on Sunday and can run any number of days. There are a maximum number of promotions that can be run at any one time so I wrote a stored procedure to add a promotion to the table and needs to find the next available Sunday that has less than the maximum nu... 21 Mar 2010 13:52
large number of sql server processes with vb6/ado app I have to maintain a rather large vb6 app using ado and the standard sql client to connect to 2005/2008 database. The application opens an ADO connection from a 'menu' .exe, then the connection is passed to a number of activex dlls making up the bulk of the application. When the menu closes, the connection is c... 21 Mar 2010 18:36
Inner Query Coalesce Causes Incorrect Query Results? We have come across a peculiar situation where we get some very different behaviour when an inner query contains a coalesce. We are flattening out a list into a comma separated string variable. The desired goal is to have a comma separated list of people in alphabetical order. People are stored in table #tbl... 19 Mar 2010 15:32
SQL Express 2008 I have Server 2008 Standard and just downloaded SQL Express 2008 from MS. The Management Studio tool is not included in the install. I then tried to download the Management Studio directly from MS and get "error on page", so no download. Where can I get this tool? All the MS documentation points me to non-e... 19 Mar 2010 20:10
Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706 Hi concerning Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) I have tried many many times to load this update and every time the error message tells me the the down-load failed. Why is that happening ... what must I do in order to down load this update. There is absolutely no help on the MS we... 19 Mar 2010 12:02 |