CASE Statement - I'm trying to add a new column to some code I have, and I am completely stumped. I was wondering if...
Exif data into a database. - Hello All, With the ExifTool by Phil Harvey I make a number of .CSV files from different media (harddisk, USB-stick, CD-rom's...
Incremental Table Copy - Hi, I have 3 huge table in excess of 100 GB each which need two be copied between two SQL 2017...
SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K - Need a maintenance query for an alarm logging table to see if the row count is more than 200K rows...
How to study the layout of a database? - Hello friends, Suppose you download a sample database, whether it be AdventureWorks, Northwind, or whatever other database. What steps do you...
Transactional Replication multiple Distributors - My current setup is as follows: Server A = Publisher Server B = Subscriber and Distributor (Push subscription) I need to now also replication to...
SP2 CU4 - I've started getting the following error when installing this patch: Error installing SQL Server Database Engine Services Instance Features File C:\Program Files\Microsoft...
Database upgrade and migration to 2016 SQL Server - I am looking for pointers on what option to take for high availability for a new SQL Server 2016 environment....
Obfuscating character columns - Is anyone aware of any resources/websites/T-SQL code that will allow me to obfuscate ALL columns in ALL tables within entire...
Inner joins - Hi all. Our current version is 2008 and we are going to migrate it to 2016 or 2017. In many stored procedures,...
SQL 2014 SSIS Dynamic Connection managers issue - I have a strange one here which has me and few others a little bit stumped. We have an SSIS template...
TempDB - Hi, Please i need your advise,to reduce TempDB allocation contention i must add more mdf files.I have a drive allocated for...
Case when inside of partition by? - Hi, I have the following situation: CREATE TABLE #TAB1( ID INT ,MY_STATE VARCHAR(10) ,EVENT_TS DATETIME ) INSERT INTO #TAB1(ID, MY_STATE, EVENT_TS) VALUES (1, 'STATE_1', GETDATE()) ...
Basic Question: Do you have to restart the instance if you change database or log file growth - Hi All, I have changed the default autogrowth to 300000MB. Do I need to restart the server instance in order...
How to find products commonly purchased together - Hi all, I feel certain this should be a common query, just maybe not using the right search. Here goes: I...
Index and Search help - Hi, The belwo is my sample table structure and I will be buildinga sample website to test the search feature. Basically...
parse string and check for valid date - I have a flat file with a bar(|) delimiter. It has no headers, but I want to check columns(11,12,13) for...
Cursors are not supported on a table which has a clustered columnstore index - Hello, I'm using OLE DB connection in SSIS, which inserts the data into SQL Server Table. I'm follwing getting error "Cursors...
Problem using expression in SSIS - Hi, Below is the expression i am trying to make work : substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2)) Whe I use the exact string(Archive_Full_20120731200002)...
Natural Sort Order - Hello. I have a table that has a column of nvarchar that has rows containing both numbers and letters... Ex:...
