SQL Server 2017 : SQL Server 2017 - Administration

DBMirroring SQL2017 - SQL2017 not starting !?! - Testing SQL2017 I've come to DBMirroring I know AG is the "new" way of handling that desire, but DBMirroring is...

SQL Server 2017 : SQL Server 2017 - Development

5 years or older - Guys, if i have a list of dates in a table how do i query how many of the dates...

SQL Server 2016 : SQL Server 2016 - Administration

Transaction Log Growth - Hi, I am currently using Ola Hallengren's backup solution for my backups on a SQL Server 2016 Standard instance. I have...

Showplan - Started a new role, have limited (read) rights to the server, I have asked for showplan rights but have been...

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

Triggers or best option - Hi, This is a little hard to explain, but I'll have a go :) We have several tables in 2 databases that...

Performance improvement following a disable indexes, shrink, enable indexes - but why? - I'm stumped and need the assistance of the wider community to understand what is going on. The database in question has...

SQL Server 2014 : Administration - SQL Server 2014

Adding multiple triggers to same table - Recommendations/Best Practices - Hi Folks, I have a requirement to add additional triggers(INSERT/UPDATE) for a table which already have INSERT/UPDATE/DELETE triggers. This is for...

SQL Server 2014 : Development - SQL Server 2014

Need a SQL Query to find numeric values - Hi Experts, Can you all help me out to find a query in which i can find all the tables in...

Looking to sort two queries by Date, Time - SELECT LTRIM(RIGHT(CONVERT(varchar(6), .,100),7)) AS --, FORMAT(., 'MM-dd-yyyy') AS , CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), .,101),'/','-')) AS , LTRIM(RIGHT(CONVERT(varchar(20),

SQL Server 2012 : SQL 2012 - General

How to import a Excel file into SQL table directly? - How to import a Excel file into SQL table directly? Before, I used vb.net to import Excel file into a datatable...

SQL Server 2012 : SQL Server 2012 - T-SQL

finding the right index - We use a program for EDI in our company. One of the screens shows us a list of sent documents. ...

Need to get consecutive duplicate rows - I need a query that can get me (the ID of) consecutive duplicate rows, where I am grouping on some...

SQL Server 2008 : SQL Server 2008 - General

Replication not working but replication monitor says all ok!! - Hi, Earlier on today one of our DBs started to fall behind and isn't replicating anymore - normally opening up Replication Monitor...

Cloud Computing : SQL Azure - Administration

Issue with using Ola Hallengren Backup script - Hi, I am using OH's excellent scripts, however I have found and issue when it comes to backing up to...

Reporting Services : Reporting Services

SSRS Reportserver parallel testing - Is there a way to run all reports on server 1 and server 2 and compare the results. So run...

Data Warehousing : Integration Services

Error uploading jgp - i have an SSIS package that takes a image in my database and uploads it into a network location that...

Need idea on exporting column data to separate file -ssis - Hi all, I need a help to generate XML file from a table output and Create main folder and subfolder...

The Microsoft Data Warehouse Toolkit -- are either of these books still relevant to learn? - Hi, I would like to learn how to design and build a full, end-to-end Data Warehouse and Analytical solution using the...

SQL Server 2005 : SQL Server 2005 General Discussion

SSIS Package Problem - Sybase Connection - Hi guys, We are in the process of upgrading to 2005 from 2000. We have a lot of legacy DTS packages...

Microsoft Access : Microsoft Access

Migrated DB to 2016, having ODBC Access problem - Thanks in advance for any clues on this problem. I'm migrating several SQL Server databases from SQL2005 to SQL2016. One...