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…

Import/Export SQL Server 2012

Hi I am trying to import data into a database table in sql server 2012 from a csv flat file and I k…

TCP / IP SQL configuration

Good day,Please help with the following.I currently have two instances, initially I had only one ne…

ssrs 2016 student id cards

In a new ssrs 2016 report, I need  to generate student id (identification) cards. The requirem…

Logging to SYSSSISLOG table does not work

BIDS 2008: I went to SSIS--> Logging menu, added logging to Event Log , chose ONERROR, On POSTEX…

How to save jobs

Hi, I was wondering on our server we have backups of our databases for course, but what can I do to…

How to get a record if any of it's column values is set to true ?

I have a table which has 20 or so boolean True/false. How do I find a record in the table which has…