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...
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...
how do i do a partial string search in a Full Text Index? - Hi I've set up a full text catalog and index on a column in my table. I need to mimic the exact...
Inner joins - Hi all. Our current version is 2008 and we are going to migrate it to 2016 or 2017. In many stored procedures,...
slow query - the query has a Where clause that 2 conditions combined via AND. If only the first condition is run it...
Slow run time - I have a query which is running slow for approx 15 mins, however, the slow run time has no impact...
Unable to execute SP - Hi, I have a colleague we cannot execute an SP they get an error saying: User does not have permission...
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()) ...
Select only one register with condition - Hi Guys, I need a help for a query development that returns only one record according to the condition. But if...
SSIS Package Foreach Loop Container not finding files when deployed (fine in DEV) - Hi there, I have a SSIS 2014 package using the Project Deployment model and parameters. I have a project parameter called...
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 add new column in a CDC(Change Data Capture) script for a table - we have a requirement where we want to enable CDC on newly added columns of table, but I cannot disable...
SQL Agent Jobs showing NO history - Hi - We migrated to SQL 2012 and now a few SQL Jobs don't seem to have job history (and I...
how to find the lowest usage of a database - Hi Guys How do we find the lowest usage of a database ? I need to find the best time to ...
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...
What is the right answer here, or how do I determine what the right answer is? - I put in a ticket to get my team into TFS to manage our database, IT is asking me this...
SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time) - Hi, I have a table with 200 000 records, I need to send a file with 50 000 records. I'm using...
DTS and Type Mismatch error - Any solutions to the DTS and Type Mismatch error (MS KB ref: Q310473). Microsoft says that it is an error...
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:...
