How would you lock down a SQL DBA to have local admin on the SQL box - I would like to know if we can create a separate group or what permissions on the server should be...
CTE Crazy: Sums, Counts and Pivots I'm missing something here - I've not had to use SQL for a while and I'm having trouble getting to grips with aggregates again. In the...
Need Tutorial on Differential Backup - I need to backup a SQL Server 2016 database weekly - and take incremental backups daily I found this snippet: -- Create a...
AlwaysOn Availability Groups Cluster Name vs. Listener Name - Hi, I've been working on setting up AOAG for the first time. I see a lot of benefits to having this...
Can I Restore with Device to Database on another Server? - my client wants me to set up an incremental database backup, which entails restoring to a device, not a file I...
SQL Server 2016 cluster issue - Hi, We have installed SQL server 2016 Standard (SP1) in two-node Windows 2016 Fail-over cluster successfully.. <by mistake> When we restart SQL...
Index Framentation - Hi, I have tables in databases with avg_fragmentation of 86% and a page count of 26 and even less page count...
Writing variable length records to a flat file destination in SSIS - I have a 132, 180, 18, and 34 column records and I need to write them to a flat file...
SQL insert auto insert with stop value - Experts, Sql need to add automatically the numbers with sequence . DDL is, USE GO /****** Object: Table . Script Date: 2/27/2018...
DTSX Pkg From Stored Procedure (completely frustrated) - Help please!! I am bruised and bloodied from mashing my head, for two weeks now, against stuff I do not...
Application starts throwing SQL error after database failover. - I have a situation and looking for some guidance. I have a two node SQL server always on on setup...
How does SQL Server handle concurrent operations? - Hello, We are having an issue which I suspect is database related. We have a web application on which we can...
Add Group ID value for set of sequential rows - Hi To be honest I wasn't sure how to phrase this subject, I hope it makes sense after I describes my...
SSRS Report: Any way to copy or download either an RDS file or the text needed to create one? - It's been a while since I dealt with SSRS. Am hoping to find an easy way to either download a...
OpenRowSet No Field Terminators - Hi, To start I have minimal experience with OpenRowSet and BCP. I usually do processing with SSIS but this new project...
How to handle very large dataset - I need to find the most recent post date for all the invoices in my table. There are millions of...
Transaction logs - We had an issue where our transaction log backup job became disabled over the weekend and didn't find out until...
union with constant values - Hello, I'm doing this: ... union select 'EVY', 'Everyone', ... from ... where ... and @Grouping = 'false' That @Grouping = false still returns the row if the value is true....
Splitting a Full Name - I'm trying to split a full name column up into First / Middle / Last....but some of the names are like "Joe...
checking for data exists in a multiple tables in single query - Before deleting a record, i have to check whether the record exists in someother tables or not.. need help in doing
