SQL Server 2017 : SQL Server 2017 - Development

SSIS Package Execution issue using ODBC Oracle Source - Hi, I'm having an issue running a package when I have an ODBC Oracle Source. When I manually execute the package...

Error Processing Cube from SSIS package run as a SQL Job - Hi, I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I tried CU4 before...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Is there a maximum number of joins allowed in SQL 2016? - I have reports that are between 6 and 100 User DefinedFunctions joined together. When I have the compatibility level set...

Getting free periods from booked periods - I have this issue. I have a table with booked items, simplified here: declare @t table(dBookedFrom smalldatetime, dBookedTill smalldatetime) insert into...

Return rows where value doesnt exist - Hello Everyone, I have a slight problem so I hope you can help. I have a table with orders joined to...

Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...

Export data in XML to import into Word - Hi Folks, I am building a one-click application to export information from SQL Server 2016 in XML format that will be...

SQL Server 2012 : SQL 2012 - General

Log shipping and database backups - Hi all We've got a few databases that we want to start log-shipping from. Normally, we'd use replication but the 3rd-party software...

The SQL Server Network Interface library could not register the Service Principal Name (SPN) but KERBEROS connections are possible - After rebooting the server running Windows Server 2012 and SQL Server 2012 there was are an entry in the error...

FileStream Encryption - I am evaluating encryption methods for filestream as I am currently using TDE for non file data but filestream data...

SQL Server 2012 : SQL Server 2012 - T-SQL

Why is this query so slow? - I have one "big" table with 300 million rows... CREATE TABLE rstore.OutputDataset(OutputDatasetId INT NOT NULL IDENTITY(1,1) ,OutputDatasetHeaderKey INT NOT NULL

SQL Server 2008 : SQL Server 2008 - General

Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis - Hello, techies, I have a table in my database named HR_Employee_Data, which has everything about particular employees like his/her first...

Federal Holiday Function - Thought this might be helpful. I've written a T-SQL function that returns a federal holiday name based on an input...

SSIS Warning - Global Shared Memory - Hi I'm busy rewriting DTS packages as SSIS packages. As and when I finish a package I run it in debug...

SQL Server 2008 : T-SQL (SS2K8)

Preserving the total field lenght - Hello comunity I have a field Char(10) named bank, and another one Char(15) named namebank. I need to create a TSQL query,...

SQL Server 2008 : SQL Server 2008 Performance Tuning

Query taking more time - Dear All, I have a table and it just have 34K rows in it. I have a non clustered index on...

Data Warehousing : Integration Services

The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it. - I get this error if i try to import a tab delimited flat file to a table in sql server. The...

Data Warehousing : Data Transformation Services (DTS)

Cannot Open Database "xxx" requested by login. Login failed - I created a DTS package using remote desktop to the server. I'm logged in as me and I'm an administrator. ...

SQL Server 2005 : T-SQL (SS2K5)

Duplicate key error when inserting into a table that has no records!!! Please help! - All, I'm having trouble with an insert statement that is throwing a duplicate error (shown below) on a table with zero...

Career : Events

The SQL Saturday Thread - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created...