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...
San block sizes - I appreciate this isn't a SAN forum. I'm exploring recommended block sizes to have for an all SSD SAN for...
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...
Tracking changes on Views. - Tracking changes in/on Views. Are there any good scripts/documents/advises/tips on Tracking changes on Views? I asume that I am not the first...
Delete 5 lac records from table - I have a table where there is a column called nationality having possible values "US" and "Non -US'. I need to...
What are SHOWPLAN security risks? Should a query optimizer person (not DBA) have access to it? - Strange situation. Myself and one other person (the DBA/ sysadmin) --- manage a Data Warehouse for a company BI. I'm a subject matter...
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...
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...
upsert in ssis for large tables - I have 40 tables having different structure in one of DB on one server that is being updated by data...
SQL uses 2 different executions plan (slow and fast) for a simple query. Need a new index ? - Hi everyone, I am experiencing a performance issue with one process in our system. The performance issue is intermittent, the users...
Question about a composite key and autoincrement - Hello all, I was recently assigned to convert an Access database to Sql Server. I have to try and keep the...
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),
Covering Index vs Include Index - I’m looking intocreating indexes and I want to know which types of indexes are better and inwhich situations to use...
SQL Server (MSSQLSERVER) keeps Stopping - Hello, Trying to connect to sql server database engine, via ssms, but won't connect. I get the standard error: A network-related or...
Query to increment an alpha character suffix - Need some help from the TSQL gurus. The situation is that given data in the column a table, data in...
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...
Enter maximum value on the basis of 2 independent tables. - Hi Folks, I stuck in a puzzle, please suggest a way to resolve this. I have 2 below Tables in my database. Tab_A...
Importing Loads of Fixedwidth flatfiles - hi i've got a big bundle of fixedwidth flatfiles to import. i have the supplier documentation to show me where the columns...
