What is the best way to store connection string in .NET DLLs? *

Question The application my team is currently developing has a DLL that is used to perform all database access. The application can not use...

Read More

User access log to SQL Server *

Question I need to get a log of user access to our SQL Server so I can track average and peak concurrency usage . Is there a hidden table ...

Read More

SQL Server 2000/5 Escape an Underscore *

Question How do I escape the underscore character? I am writing something like the following where clause and want to be able to find a...

Read More

Tables with no Primary Key *

Question I have several tables whose only unique data is a uniqueidentifier (a Guid) column. Because guids are non-sequential (and they'...

Read More

SQL Server 2008 FileStream on a Web Server *

Question I've been developing a site using ASP.NET MVC, and have decided to use the new SQL Server 2008 FILESTREAM facility to store...

Read More

SQL Server Management Studio alternatives to browse/edit tables and run queries *

Question I was wondering if there are any alternatives to Microsoft's SQL Server Management Studio? Not there's anything wrong wi...

Read More

Locking a SQL Server Database with PHP *

Question I'm wanting extra security for a particular point in my web app. So I want to lock the database (SQL Server 2005). Any suggesti...

Read More

How much database performance overhead when using LINQ? *

Question How much database performance overhead is involved with using C# and LINQ compared to custom optimized queries loaded with mostly l...

Read More

MOSS SSP problem - Failed database logons from deleted SSP *

Question We've been having some issues with a SharePoint instance in a test environment. Thankfully this is not production ;) The probl...

Read More

SQL Case Statement Syntax? *

Question What is the complete and correct syntax for the SQL Case statement? Answer The complete syntax depends on the database engine y...

Read More

Drop all tables whose names begin with a certain string *

Question I'd like a script to drop all tables whose name begins with a given string. I'm sure this can be done with some dynamic sql...

Read More

What is best practice for FTP from a SQL Server 2005 stored procedure? *

Question What is the best method for executing FTP commands from a SQL Server stored procedure? we currently use something like this: E...

Read More

What program can I use to generate diagrams of SQL view/table structure? *

Question I've been tasked with redesigning part of a ms-sql database structure which currently involves a lot of views, some of which co...

Read More

How to enable Full-text Indexing in SQL Server 2005 Express? *

Question I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate. I under...

Read More

How do I know which SQL Server 2005 index recommendations to implement, if any? *

Question We're in the process of upgrading one of our SQL Server instances from 2000 to 2005. I installed the performance dashboard ( ht...

Read More

T-Sql Remove Decimal Point From Money Data Type *

Question Given the constraint of only using T-Sql in Sql Server 2005, is there a better way to remove the decimal point from a money datatyp...

Read More

Suggestions for implementing audit tables in SQL Server? *

Question One simple method I've used in the past is basically just creating a second table whose structure mirrors the one I want to aud...

Read More

Backup SQL Schema Only? *

Question I need to create a backup of a SQL Server 2005 Database that's only the structure...no records, just the schema. Is there any w...

Read More

Sql to query a dbs scheme *

Question In SqlServer. How do you query a db to bring back all the tables that have a field of a specific name? Answer The following query...

Read More

Transform Columns into Rows *

Question I have a very simple problem which requires a very quick and simple solution in SQL Server 2005. I have a table with x Columns. ...

Read More