Speeding up bulk inserting in SQL Server 2005
Is there any way to speed up bulk inserting in 2005? I'm looking into partitioning, is it good? ...
sql-server-2005
Update products table based on sku prefix
I have a products table, that has a manufacturerID that is currently -1 for all the products. I have a manufacturer table that has a SKU prefix. So if a MFG sku prefix is: ABC Then the products table will have products like ABC123, ABC3434. So I need a query to update the products table, to set the manufacturerID based on the skuPref...
Error checking in .NET with SQL 2005
Can I throw an exception on the SQL 2005 server so that I can catch it in C# code with SqlCommand.ExecuteQuery()? ...
It is possible to create a insert trigger inside a stored procedure?
I want to create a insert trigger that checks the valid data(calculating on sql server by taking the values from user)before insertion takes place.So i perform the calculations on stored procedure and now if data are valid then i want trigger fired.Is it possible ? if possible is it good practice? ...
Powershell Transcript is empty when running script from SQL Agent Job in 2005 SQL Server
I have a complex Powershell script that gets run as part of a SQL 2005 Server Agent Job. The script works fine, but it uses the "Start-Transcript $strLogfile -Append" command to log all of it's actions to a transcript file. The problem is that the transcript is always empty. It adds the header and footer to indicate that the transcript i...
SQL: Show average and min/max within standard deviations
I have the following SQL table - Date StoreNo Sales 23/4 34 4323.00 23/4 23 564.00 24/4 34 2345.00 etc I am running a query that returns average sales, max sales and min sales for a certain period - select avg(Sales), max(sales), min(sales) from tbl_sales where date between e...
SQL 2005 Security - Users: What are they used for? (and other various questions)
Hello I am not a DBA and so dont really know anything about SQL 2005 security settings, etc. I am attempting to set up an empty copy of our database by generating the full database from SQL Management Studio generated scripts. Unfortunately I don't know what many of the options do and the MSFT documentation of this processes isn't great...
Delete SQL Server 2005 records without logging
How to delete records from SQL Server 2005 tables without logging them into transaction logs. I do not wish to log because once deleted, those records will never be needed again. Currently the various deletes take too much of time. Are there any other options to improve performance of delete statements? I can not use truncate since t...
format is changing SSRS Report
See this Image below http://i46.tinypic.com/2pt6jkn.jpg This is report in SSRS as shown when it is uploaded in the server. On my developement machine, the format is ok as shown in the pic below. http://i48.tinypic.com/be9dmh.jpg Why is the format getting messed up? ...
Common table expressions, how to avoid infinite recusion when traversing a graph?
I have a simple weighted graph A 1 / \\ 0.5 / \\0.5 B C Suppose this describes a family and A is the father, B is the son and C is the mother. Let's say B is studying in an university and A has bought an apartment for him. A is living with C in a house which is commonly owned, 50-50. I want to transform the graph into a...
how to migrate DB from MySql to MS-SQL?
i want to migrate my whole DB from MySQL to MS-Sql server. though i am open to use any tool,am restricted to use only free avilable tools. ...
SQL Server Query Performance - Clustered Index Seek
Excuse the long post, but below I have included a full script to generate and populate my test harness. My test harness has the following tables |--------| |-------------| |-----| |--------------| |Column | |ColumnValue | |Row | |RowColumnValue| |--------| |-------------| |-----| |--------------| |ColumnId| |ColumnValueId|...
SQL Server 2005 identity incrementing by itself
Hey. I have a table with an identity column that have incremented by 1 for all its records then suddenly last week it started incrementing in a weird way. For example Identity - Date 31891 2010-02-27 09:47:41 39258 2010-02-27 13:13:03 41994 2010-02-27 13:43:56 45119 2010-02-27 14:44:43 45120 2010-02-27 14:51:33 45121 2010-02-27 1...
Is it possible to switch to a database on a linked server using a 'USE' statement in SQL Server 2005?
I've tried the obvious: USE linkedServerName.databaseName Which gives me the error: `Could not locate entry in sysdatabases for database 'linkedServerName'. If something like this were possible, it'd save me a bunch of clicking around in management studio! ...
Database running at 100%
My database server is using 100% of the processing all of a sudden and it doesn't seem like I have any more traffic on my sites. What can I do to look where the increased traffic is coming from inside of SQL Server Management Studio? ...
What is the best way to perform a manipulation with huge amounts of data in SQL Server ?
We need to perform the following operation in our database : There is a table A which has column B_ID that is a foreign key to the table B. There are many rows in the table A that have the same value of B_ID and we want to fix this by cloning the corresponding rows in B and redirecting the rows from A to them. All this is relatively si...
Extracting data from multiple servers SQL 2005 SSIS
I have created an SSIS package to connect to multiple SQL servers, create a database, a table and a stored procedure. The package also creates a job and schedules it to run every 5 minutes. The requirement is to collect performance metrics. I am using an ado object variable to get the server names and all the above tasks are in a for ea...
How do I open the ASPNETDB.MDF database?
I am using vusiaul studio 2005. I have been unable to use the express database. I can create it, by simply tryign to log in. But if I try to open the ASPNETDB.MDF database itself I get the following error: "This server version is not supported. You must have Microsoft SQL Server 2005 Beta 2 or later." I have SQL 2005 loaded on my mach...
How can SCOPE_IDENTITY return null when @@IDENTITY does not?
After executing an insert, I either select SCOPE_IDENTITY or @@IDENTITY. SCOPE_IDENTITY returns null but @@IDENTITY does not. I don't understand how this is possible. Can you think of a reason why this happens? ...
Passing Forms Auth User credentials to SQL Server database connection
My web app is using .NET 3.5 framework, VS 2008 with a SQL Server database. I am using Forms authentication and the generic login to validate user access to the aspx pages. Is there a way I can pass the user's form auth credentials (different from their Windows login) to the sql server connectionstring so that their database permission...