I'm getting some conflicting information , regarding sql 2005 Standard Edition licensing for multi instancing. If you have multiple instances of...
Hi I'm troubleshooting a performance issue , Looking at Profiler - for the given statement, I'm getting the following figures , why would there...
Hi I have a sql statement running on 2 different servers , and getting a performance disparity. SERVER 1 - Windows 2003 Service Pack 1 , sql server...
SQL Server 2000 Enterprise Edition At certain times of the day the transaction log files created are to large to be handled by the Log Shipping...
Is it possible , without using the installation CD , to create a new INSTANCE of SQL Server 2005 from an existing INSTANCE on the same server?
I did an initial file size of a db to 100GB . The backups reflect the true size of the DB (about 3GB). However if you try and restore the DB it...
i've currently got a user who is a "public" on a given database. Is the only way I can give them access to mange "jobs" on the server is by...
I'm thinking through a problem , and have come up with 2 potential options: Firstly , the problem is: a .Net application is executing some stored...
If you have a column, of data type = INT, with the following numbers as separate rows. 1 3 4 5 7 10 How can you write a sql statement where you can...
I've never done BITWISE operations and I would like some explanations. I have a 26 bit number as an INT data type "124005" and I would like to...
Currently, I've got 2 tables . We are dealing with about 400,000 rows, of 6 colums all data types are INT . Table1 - no indexes ( as we want as...
I've connected to a SQl Server 2005 , through a 2000 Query Analyzer. I can see the list of stored procedures , but I can't actually open them to...
I'm looking at setting up a SQL Server 2005 app that deals with a very write intensive system . Currently , it's a very simple table structure ,...
Is it possible to issue a command within a stored procedure to NOT save to the Transaction Log File? The situation I've got at the moment is the...
I'm doing some research on time-critical processing of large volume of data. Would anyone be able to point me in the direction of a white paper that...
Currently I've got a process where I do a save on a number of web pages , save the files to disk and then call the saved files from within a stored...
I'm using a FullText CONTAINSTABLE which is doing a Remote Scan and returning 2000 rows, this is INNER JOINED on the base table , which then does a...
I'm doing some wait type analysis. I've hit a peculiar set of stats. The wait type is OLEDB , which is 23% of all wait times but takes up 94.4 % of...
I've got this sql statement (see below) , which has some performance issue.I've run a Execution Plan and one of the high cost aspects is the...
I'm currently analysing a web app (ASP 3.0) with a SQL Server 2000 db. The web app is creating dynamic sql statements depending on user parameters....
Separate names with a comma.
