Column encryption advice - All, If possible I would appreciate your advice on my plan and questions. Situation: I need to encrypt certain columns against the risk...
MS-SQL 2016 Eating Memory - Hi All, I'm a newbie here and in general to MS-SQL but I've been thrown in at the deep end and...
Worse Page Compression after upgrade to SQL 2016 - We have a table with Page compression which is partitioned daily. Before upgrading from SQL 2014 to SQL 2016 each...
T-SQL Help on same table join - Hi SQL View SELECT a.Name , Q0.Value, Q.1.Value,Q2.Value FROM A with (nolock) Left Outer join B AS Q0 ON Q0.FK_ID = A.ID AND Q0.Type...
Salesforce data and missing foreign keys - For reporting purposes we have synced our SFDC data onto a SQL server using a third party middleware. Everything looks great,...
Database Mirroring Issue - Hello Team, I have a database which was mirroring currectly to DR successfully until the principal database crashed due to fried...
Extract to CSV File - I have data something like below for one of the column. ADDRESS 2248|("snake") ft NE, FTE 700 When I extract this record to...
Code for 'week to date' DATETIME() mine is displaying previous weeks - (Invoice_Exceptions.DateTime >= DATEADD(dd, DATEDIFF(dd,'17530101', GETDATE()) / 7 * 7 - 7, '17530101')) AND (Invoice_Exceptions.DateTime <= DATEADD(dd, DATEDIFF(dd,'17530101', GETDATE()) / 7 * 7, '17530101')) This code...
Select data based on multiple date criteria - Hi Guys, My company are looking at sending out customer satisfaction surveys to our customers. There are two different date criteria...
How to get columns which has null's - Hi Experts, Need some tsql help. I wanted all the column names from all below 3 tables which has nulls. i.e....
TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO - Hi guys, i wonder why executing a TRUNCATE and INSERT INTO Command is mutch slower than executing these commands separately ? Conditions: recovery...
Help in finding events in two-week period - Hello everyone,
OPEN TEXTFILE FROM T-SQL - Hai Friends, I have this TXT FILE And I want to create Stored Procedure to insert to TEMP TABLE With each name of...
Handling string column with dates - I imported a csv file that has a column with dates. The column is a varchar type and it has...
Stock take FiFo conundrum - Hello, I'd very much appreciate some advice/help with a stock take problem. I've had a look at https://ask.sqlservercentral.com/questions/1961/the-fifo-stock-inventory-sql-problem.html but my scenario differs somewhat....
How to create a summary for a dataset - My report consists of a list of patients, location in the hospital, and a column called "TobaccoUseWithin30Days. The values in this...
SQL Native client driver 10 vs 11 - Has anyone experienced a difference between SQL driver SQLNCLI11.1 vs 10.1? I inherited a complex SSIS package where I had to...
sql backup to avamar - Is anyone using avamar backups to do live backups of sql server? are there any issues, are there problems? AW
The database cannot be recovered because the log was not restored. - Hi, my db name is abc.. i hv restored the bckup on tht db.. But in middle i have cancleed the...
Project Plan - I'm looking for a decent Project Plan (in any format) for moving from SQL Server 2000 to a SQL Server...
