auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases - Hello everyone I am looking to generate a restoration script for hundreds of databases with their backup Full and log file...
SSISDB packages move - Hi, Looking for an advice in SSIS migration from 2012 to new version of SQL packages exists in all places..SSISDB,MSDB.Filestore . Current system...
split data in equal halves - Hi, I have source data as below. How can i split the data into equal halves and get the other half...
How do I convert a uk date in string format to date? - Hi A user enters a date in uk format (i.e '24/01/2019') into a web form (.net). I then call my stored...
upgrade to 2016 causing performance problems - Hi all Experts, We have strange problem (at least for our case), we have database in 2012 which was restored...
Export multiple query results with different columns (name and number of columns) into one sheet of CSV file - Hi Experts, I have three different queries which returns three different sets of data with different column names/number of columns from...
Move clustered index to a new filegroup - All, I'm trying to move a clustered index (and therefore the table) to a new file group. It won't let me...
Split column values using delimiter and insert them into referenced table - Hello, I am copying few million rows from Table1 into Table2 via INSERT INTO...SELECT. Caveat is that 1 column(Column5) in Table1...
Sort already comma separated list - Hi I have values like this in a column which basically is the exact same thing if sorted . ORM;
Copy Backup File - Hi Experts, We have backup job taken every 20 mins(trn) every 1 hour(diff) and weekly full. These backups are taken to...
Need Help with Views - SQL Server 2014 enterprise edition 64 bit Windows server 2012 R2 Standard Edition 64 Bit Database A TableA Create Table TableA ( Varchar(10) NOT...
Fill Factor for OLTP database - I am setting up a new OLTP database and expect to write to the database about 70% of the time...
SQL 2014 Execute Package Utility Error - This question is regarding a SQL 2014 package not running on my local machine when using Execute Package Utility. I have...
Find individual column mismatch between source and target - Hi All, Source table: CREATE TABLE EMP_CLIENT( ID INT NOT NULL, NAME VARCHAR (20) NOT NULL, AGE INT NOT NULL, ADDRESS CHAR (25) , SALARY DECIMAL (18, 2), ...
Merge Multiple Rows into a logic - Good Day, Please find below my requirement : --SOURCE TABLE CREATE TABLE .( (20) NULL, (20) NULL, (40) NULL, &nb
Bulk copy from one server into another server. - I have table contains fifty lakhs records and one of its column contains PDF data in blob column .I want...
Log file backup failure for two jobs - Hello -- Two backup jobs for the log files on our server started failing this afternoon. I have been going over...
Question on Grouping -Working number of days - Hi All, I am trying to work out the number of days for each (CODE) from the Code (REQUEST DATE) till...
Query Question - I have a table that contains multiple fields: Diagnosis1 Diagnosis2 Diagnosis3 Diagnosis4 Diagnosis5 Diagnosis6 Diagnosis7 Diagnosis8 Diagnosis9 each field only contain codes, the descriptions are in another table. What I...
How to find the blocker? - I have encountered a situation when I cannot find out what stored procedure or query is blocking others. Here I...
