SQL Server Job which downloads the files using Script Task fails after few runs on the Agent - I have an SSIS Package which uses a script task to download some zip files daily from websites. The Package is...
Issue with midnight in stored procedure - I have a very straight forward check in a stored procedure that makes sure an EndTime was entered from an...
Email results of Failed Jobs - Thanks you for your time and any help or questions are appreciated. Currently i have approximately 300+ jobs...and trying to get...
Subquery - another way to achieve the same result? - All, I have the following DDL/DML: /****** Object: Table . Script Date: 13/12/2018 23:44:46 ******/
Stumped trying to shred XML data into table rows - Hello experts, I have the following table: MyTable ( MyKey varchar(100) not null primary key, ColXml varchar(max) null ) The ColXml column has xml data...
Stuck Parallel Query - I've never seen this before, and I have no idea what to do (other then kill the SPID). Third party vendor...
need 3rd day of Calendar month - date precision to exclude minutes - I need query (in my case an INSERT) to run only if today's date is 3rd day of Calendar Month? how...
how to speed retrieving data from big table data when select from it? - Problem I have table have 20 columns when make select data from new SQL query&
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...
CREATE EXTERNAL DATA SOURCE - Im trying to extract data stored as a csv file in azure blob storage and import it into my main...
Suggestion on import data - Hi, Every month I will import data into table. The data doesn't have any primary key. It has year and month...
How to clean buffer cache without using DBCC command? - My situation is that I don't have permissions to run DBCC dropcleanbuffers/freeproccache, but I need to find a way to...
How Check string of Boolean expression is return true or false - Hi Guys, I have a requirement in my project is how to check string of boolean expression is true or...
PERCENTILE_DISC for median calculation - Question: is PERCENTILE_DISC for median calculation works for both odd and even number of records? In SQL Server 2008 to calculate...
Can it be improved again? - Hi there, I have want to modify a SP to select item's activities from a main table of 2 million...
Automaticaly Build and Deploy SSIS packages. - Hi we're trying to automatically build and deploy an SSIS package up to the Integration Services Catalogue when we check changes...
SQL Server Active Directory helper? - Hi I am not able to start SQL Server Active Directory helper in my server 2003. What is the use of...
Do recruiters primarily recruit for contract jobs? - I live in New Mexico (yes, we're part of the USA, despite opinions to the contrary). New Mexico is primarily...
