sql-server

Please can anyone explain How to read a Execution Plan for Poorly Performed Query in SQL Server?

Please can anyone explain How to read a Execution Plan for Poorly Performed Query in SQL Server? ...

What are the differences between a Differential Change Map and a Bulk Change Map?

What is the difference between a Differential Change Map and a Bulk Change Map? ...

What is wrong with Cursors ?

Hi, SQL Server developers consider Cursors a bad practise , except under some circumstances. They believe that Cursors do not use the SQL engine optimally since it is a procedural construct and defeats the Set based concept of RDBMS. However, Oracle developers do not seem to recommend against Cursors. Oracle's DML statements themselve...

publishing SQL 2005 Database to Remote Host

Hi, I've made an ASP.NET 2.0 website and it uses two databases namely aspnetdb and my_db.I ran the aspnet_regsql.exe -E -S localhost -A mr tool and I got the aspnetdb.mdf in my project.I used it for providing login features to my site. Now i want to publish the site to a remote hosting server which I've purchased. They have provided me ...

How do I know if my stored procedure is removed in MS SQL Server?

It happens sometimes, how do i get to know when my stored procedure dropped/removed without my knowledge? It annoys me whenever I debugs and found to know that the stored procedure doesn't exits, which created and tested some days ago. Is there a way to know the removed Stored Procedures in MS SQL Server? ...

SQL Server indexes - ascending or descending, what difference does it make?

When you create an index on a column or number of columns in MS SQL Server (I'm using version 2005), you can specify that the index on each column be either ascending or descending. I'm having a hard time understanding why this choice is even here. Using binary sort techniques, wouldn't a lookup be just as fast either way? What differenc...

How to automate tests for reports in SSRS

My current project uses SSRS as the reporting engine. I have the report executing a text command with about 10 variables passed to it. I have been looking for a solution on how to unit test (acceptance or integration, whatever, just some automation) to an SSRS report project. I thought about using this method: Move the SQL text comm...

Dynamic selection of dataset in SSRS

Hi, Please clarify me with this. I am going to design a report using SSRS 2005. Is it possible to have the selection of dataset done dynamically. Lets say i am going to have two tables, first one is the summary and second one is the detail data. One of my parameter (with values 'Summary' and 'Detail')is deciding which version of the r...

Test Before Attempting Exclusive Lock

I've written some code to upgrade a SQL Server database. Before I upgrade the database, I attain an exclusive lock via: ALTER DATABASE Test SET SINGLE_USER WITH NO_WAIT However, I'd like to test the database to see if the exclusive lock is possible before I run the above code. The test doesn't have to be 100% perfect, I'd just like to...

T-SQL Arithmetic overflow: which column?

In MS SQL Server 2005, when encountering an "Arithmetic overflow error converting numeric to data type numeric" during an INSERT, is it possible to discover which column's input value caused the error? There seems to be a number of similar conversion errors that don't report which column provoked the trouble. This makes fixing mistakes ...

Does each instance of SQL Server on a cluster require its own LUN?

I'm setting up a Misc SQL Cluster (Windows 2008/SQL 2005 & 2008) that will be active/active and have about a dozen SQL instances on it. From the documentation I've read, I can't tell if each SQL instance will need its own LUN, or if I can have a single, really big LUN created, and then create a dozen different partitions on that LUN (one...

Database design help with varying schemas

I work for a billing service that uses some complicated mainframe-based billing software for it's core services. We have all kinds of codes we set up that are used for tracking things: payment codes, provider codes, write-off codes, etc... Each type of code has a completely different set of data items that control what the code does an...

OleDb vs DataReader When Reading Data From Oracle

Is it faster to use 1 type of provider over the other? We are using SSIS (SQL Server 2005) to pull some data from Oracle and import it into SQL Server. It was my understanding that OLEDB is faster, because the connection is native, and the data isn't being run through any .NET code? Is this correct? ...

What is a good SQL Server 2008 solution for handling massive writes so that they don't slow down reads for users of the database?

We have large SQL Server 2008 databases. Very often we'll have to run massive data imports into the databases that take a couple hours. During that time everyone else's read and small write speeds slow down a ton. I'm looking for a solution where maybe we setup one database server that is used for bulk writing and then two other databa...

How do you call a Stored Procedure in SSIS?

I am trying to create an SSIS package that queries data from a table, and calls a stored procedure in another database with each row. In my old DTS package, I was doing this: EXEC myStoredProcedure ?, ?, ? ...and then I mapped the parameters. However, in SSIS, I can't figure out how to make this work. I have a Data Flow task, which...

Can MS SQL Views have primary and foriegn keys?

Is it possible to define primary and foreign keys for database Views in Microsoft SQL Server Management Studio? How? I'm trying to create an ADO.NET Entity Data Model to read from four old, poorly-formed database tables that I cannot modify. I've created Views of just the data I need. The four Views should map to a simple three-entit...

does SQL Server consider culture/locale when converting values to/from strings?

I'm attempting to update a large codebase to properly specify the CultureInfo and/or IFormatProvider when formatting/parsing values. For instance, when parsing a value I get from the user, I pass CultureInfo.CurrentCulture when calling TryParse, and when converting a float to a string for persistence, I pass CultureInfo.InvariantCulture ...

Should static database data be in its own Filegroup?

Hi folks, I'm creating a new DB and have a bunch of static data that won't change. If it does, it will be a manual process AND it will happen very rarely. This data is a mix of varchars and Geographies. I'm guessing it could be around 100K or so in total, over 4 or so tables. Questions Should I put these on a READ ONLY filegroup Ca...

Is the OLEDB provider managed or unmanaged?

Is the OLEDB provider managed or unmanaged? ...

Left side of a floating point number in Sql Server

I have a query returning a column of floating point numbers but I am only interested in the number before the decimal place. I don't want to round the number so I am looking for something like: 1.95 = 1 1.45678 = 1 12.00 = 12 12.9999 = 12 Is there an easy way to achieve this in SqlServer other than doing a substring? ...