Store Procedure - I have a store Procedure which generate output as one random number I need to execute 100 times how can I...
Failed to lock variable - Hi, I have created a SSIS project. In that I have created 3 dtsx packages (Mastertable.dtsx , FullLoad.dtsx,Fullload1.dtsx) Now when I merge...
Query never completes with CXPACKET waits - Hi, I have a query that runs in under 40 minutes on our test server but never completes on the production...
Is not null 2 columns... - Hello ALL! I have this table CREATE TABLE .( NOT NULL, NULL, NULL, NOT NULL )
Performance improves after reboot - I am an ETL Developer who was asked to look at SQL Server performance problem. We have two DBA's but they're...
Instead of Update Trigger - Hi , I created a instead of update trigger . Something like below. Can this be modified and instead of two updates...
Joining INSERTED and UPDATED tables when PK column changes - Hi SSC, First off, as should probably be as common as to need no explanation, I did not build the system...
Trouble with openxml query - Hello, I have an XML document formed like the attachment. I have it in a table which ddl is: CREATE...
Delete the duplicate records of table having only one column - Hi all, Kindly suggest or share such query to me , How we can delete the rows having duplicate records Condition; Table having...
How can I create a table schema based on reading samples from a text file? - I have done this in Hadoop with csvkit to generate a table's schema by reading certain numbers of data from...
Efficient way of writing this stored procedure (Takes too much time to run) - Dear all, We have a query which results all the records which are unpaid as of transaction effective date provided by...
Can anyone recommend a working sample ETL package created with SSIS? - I am looking for a working package, I came across this one from Microsoft's Tutorial, unfortunately just like many observations,...
To insert 50 parameters data into a SQL table, which way is better (fast insertion)? -
Non-ANSI equal join - SQL 2012 - I recently found a non-ANSI select statement with equal joins executing against a SQL 2012 (compatibility mode SQL Server 2012(110))...
Use variable in the Identity Seed of create table - There are several tables that were created using a lookup Table to get the Primary Key as opposed to defining...
How to break down time span in Categories - Basically I have list of the tickets (records) in the db table ticket, and I need to find how long...
Using TLS 1.2 - We have SQL Server 2008R2 SP3 and I did the following A: Enabled TLS 1.2 B: Installed SP 3 B: Installed the...
SSRS Subscription cannot be created because the credentials used... - I am trying to create my first subscription on my SSRS webpage and I'm getting an error that says "Subscriptions...
Getting the first of the month based on yesterday's date - Hi All, I have tried several things and it's not doing quite what I need it to. So I have this expression...
Is having a lookup table that is for multiple entities a common practice? - I've been programming and designing databases of various sorts for several years. And I've been on teams who have designed...