SQL Server 2016 : SQL Server 2016 - Administration

Licensing of SQL Standard 2016 (and SSIS) as Management Instance alongside SQL Express - I have a client with an in-house database which is being ported to SQL Express. They have around 25 users...

Migrating Databases from old version to new version- in shortest time - Hi, To migrate lots of databases (~1200 ) , ( some of them VLDB 500 GB ) on a Fri- Sun Maintenance Window 1.Schedule a maintenance...

Different unused table space on SQL Server 2012 vs 2016 - Hello, I have two servers (different versions) with two same databases, but on Server2 one table is more bigger than on...

Upgrade to 2016 questions - All, Unfortunately we are still running a SQL server 2000 server. I've got provisional approval to upgrade it this year so...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Renumbering key column in SELECT query - I'm having a little trouble trying to a simple thing.. We have a surrogate key column that I don't want to...

what is sql logic needed to categorize objects by how much they have in common with other objects - I do not know where to begin to solve this with sql and would like advise for tackling problem/or sample...

SELECT @local_variable '=' Versus SELECT @local_variable '+=' - Hello, I am trying to find out what is the purpose of using += when selecting a local variable to the...

SQL Server 2014 : Administration - SQL Server 2014

Modify Column - Tried to change the datatype from nvarchar(250) to nvarchar (20) using below script and its threw error ,but the same...

Remove all leading zeros from a column of data in SQL? - I have a data table called 'ItemNum' The column is a SKU, which is all numbers...the current format is: 028200136107 I need to...

Refresh table data from Prod to UAT - Hello Folks, What is the best approach to refresh UAT table from Production. Tables have foreign key constraints and identity keys....

SQL Server 2014 : Development - SQL Server 2014

row size exceeds the maximum 8060 - When we tried to access a table from .net code we get this error: An unhandled exception of type'System.Data.SqlClient.SqlException' occurred in...

Differences in this where statement - I'm modifying a few queries to make them more efficient and have had success using the following technique. Instead of manually...

SQL Server 2012 : SQL 2012 - General

performance information for sql server and databases - Guys I would like to know in SQL Server how I get specific performance numbers. For example, how long did...

ssl with wildcard certificate - Hello all, I have SQL Server 2012 and want to encrypt my connections by using a wildcard (*.domain.com) ssl certificate from...

SQL Server 2012 : SQL Server 2012 - T-SQL

insert query takes too long .... - I have a insert query in stored procedure it takes min 59 or 110 specs to insert into table. query is insert...

SQL Server 2008 : SQL Server 2008 Administration

Database Documention Tool - Hi All, Can any one guide me to find what is the best sql server database documentation tool? I have searched...

Programming : General

displaying 2 values when field same - I have a field, stop.city_name, and it can be 2 different locations based on a stop.stop_type...so I'm trying to display...

Hierarchy without cursor/loop - Hi Experts I have a situation in which I want to avoid cursors/loops .Suppose I have a table in the below...

SQL Server 7,2000 : Replication

Could not find stored procedure .... error 2812 - Hi There, I am running sql server 2000 sp4. I am trying to do a transactional replication of a large amout of...

Microsoft Access : Microsoft Access

trying to upsize MSACCESS 2010 to sql server 2008 - Using sql server migration assistant 7.3 to try to upsize an MSACCESS database. When I select the MSACCESS accdb files...