sql error

Resourse Governor in SQL2008R2

Can we restrict a buffer pool for a user using resource governor?

http://www.stronghealthzone.com/brain-maxima/

Here are a couple of winning programs. Every habitual Brain Maxima starts with a characterless Brai…

moved server - now using wrong sent from email address

Hi, I just moved our SSRS server from one machine to another. It was sending our report emails from…

UNPIVOT T-SQL query

Hi All, I have a table as following . i am writing a query to extract data for a report. i need the…

SQL in SSIS

I have 2 table STG is my source table and Finaltest is my target table I have 2 column in source ta…

database corrupted

Hi, Database is corrupted, Do you have any recommendations how to know which object is corrupted ? …

Can a excel be passed as stored procedure parameter

Currently i am using SQL Server 2012 Import/Export Wizard to upload data to sql tables manually. Ho…

How to check SQL Sever 2012 License

Hi, Please let me know how to check the 1. installed SQL Server 2012 Standard Edition 64-bit is PE…

HOW TO CHECK IS OBJECT VARIABLE CONTAINS VALUE OR NOT

Hi There, Im giving an object variable as input for foreach loop. Value for the object variable was…

Master Data Services - Delete / Reinstall Web Application

Hi, I have a bad web application install for Master Data Services. This was the first installation …

Getting problem in comparison

Hi, Could you please help to sort out comparison problem DECLARE @TIMESTAMP varchar(30)='EventTime…

Not returning results in Production environment

Hello everyone, I have this script that captures metrics and sizes using T-SQL. When running in dev…

Alter all/specific columns by double dynamic SQL

Comments posted to this topic are about the item Alter all/specific columns by double dynamic SQL -…

SSAS Migration from 2008 r2

Trying to help plan a migration to 2014 from 2008 R2. Anyone done this with SSAS? What gotchas b…