Using User!UserID in SSRS to access data in SSAS Cube

I am running SQL 2012 and I have a SSAS multidimensional cube that holds measures for our retail bu…

Using User!UserID in SSRS to access data in SSAS Cube

I am running SQL 2012 and I have a SSAS multidimensional cube that holds measures for our retail bu…

Need to select rows with the latest date only

In the attached  image, i need to change the query to return only the rows with latest Recruit…

Question regarding Multiple DB Users to a single SQL Login

Currently we have 1 DB User mapped to a unique SQL Login.  The way the software vendor (that m…

SSIS to load complex Excel files

Hi,I want to load the below table into SQL Server Database using SSIS package. Can you one please t…

SQL server Audit Trigger for INSERT , UPDATE , DELETE

SSIS to load complex Excel File

Hi,I want to load the below table into SQL Server Database using SSIS package. Can you one please t…

TLS Connections to SQL Server

Hi SQL Server Central users,   Thank you for looking into my question.  I have SQL S…

Feature request, please...

Not sure if the forum software will do this, but if it can, PLEASE add a "ignore topic" option.Yes,…

Options to assign a dynamic content to XMLNAMESPACES area

I have a long running process, generating XML files with XML Namespaces, which are defined using WI…

Recovery of database

How can we check the corruption of database with out running dbcc check db

Log shipping restore

Hi All,Thanks in advance for your help.I am looking to setup log shipping to a report server but I …

How to PIVOT various VAT breakdown options with Invoice Summary data

Countries like Canada have certain consumption taxes to be applied, when selling products, e.g. GST…

MAXDOP ,Server Core & SELECT

Hi Experts, I have a complex select statement with Union All and have multiple select inside which …

How can reduce database log file size

Hi, Is it possible to reduce database log file (.ldb file) ?Can you advise any method to reduce log…