Why QUOTENAME is important

Comments posted to this topic are about the item Why QUOTENAME is important Thom~ Excuse my typos a…

Backup Compression

Hi,  I'm just starting to explore the option of compressing our db backups to save some space …

Inserting multiple rows of data in single temp table

Hello, I have this basic script. I get the following error when trying to insert values:Msg 156, Le…

Login and user SID dont match, but login still works.

I have a scenario I thought was impossible.  The login below has an sid that doesnt match the …

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…

The Application is not installed VS 2017

HiI'm getting two of errors above, I have repaired my VS but still nothing, when I right click to f…

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

Verifying the restore

Comments posted to this topic are about the item Verifying the restore

Storing values of package variables in user table in any database

Is it a good practice or not instead of using configs/xml/text/etc.  justcreate 1 table somewh…

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…

Find the second occurrence in the string

I have standard data as C1588-27-3C1588-28-3C1588-29-8 I want result as  in SQL as 1588-271588…

How to create a cartesian table?

Hello , I have this sample data: create table ##Test ([Primary KW] varchar (100), [Secondary KW] va…

BCP Error

Hi All: I'm trying to import data using bcp however, my I keep getting the below  message. I h…

Design the tables to consolidate the kafka messages

Hi All, I have below scenario: 2 DBs: DB1 and DB2 which will later replace DB1.…

Weird db_owner permissions issue

I have a developer who is a member of the db_owner database role in one of the databases he's respo…