Joining dates to calculate payment month dates

Hi I need some help and new to SQL and this forum.Please advise.I have a scenario if an employee jo…

Transaction Log when FIXED size, does it hang?

If I restrict the Transaction log to a fixed size (no auto growth) and then do a large delete, what…

Finding a String Anywhere in Another String

Comments posted to this topic are about the item Finding a String Anywhere in Another String

Remove duplicates Access

In SQL Server this is much easier because I can use Window functions and ROW_NUMBER()... Is there a…

While loop runs forever with no records in cursor object

Dear Friends,I am new to TSQL programming . Need your help in making this SP work. The first test c…

The Age of Multiple Databases

Comments posted to this topic are about the item The Age of Multiple Databases

ssrs 2012 report written mailing labels

In a new ssrs 2012 report, I need to write a report that is written like mailing labels. Basically …

Unused space; shrink or not shrink

Hi,I have some experience with the SQL Server databases but I'm not trained as one..., so mayb…

Bulk loads versus Bulk inserts (Oracle DB as data source)

Dear all, I was speaking with one of my developers about the possibility to use bulk inserts to mov…

Is SQL Server Mature?

Comments posted to this topic are about the item Is SQL Server Mature?

Foreign Keys

Is there any merit in having a foreign key which references a non-clustered index in another table,…

PREEMPTIVE_OS_GETPROCADDRESS

Happy Friday all!!! We use LiteSpeed for all our backups and have noticed the lovely new (guest not…

Write a SQL queries for the following questions in the below image?

Using an ALIAS table name in a CASE statement

Hi there everyone I'm trying to use an ALIAS table name in a CASE statement, but I'm hitting proble…

WEIRD CHARACTER IN THE ROW!!

Hello fellows, Today one of the team was working in a SSIS package and it had some issues and he tr…