bruce-347665 (10/18/2012)

---

I ordered the sql2012 standard edition but takes around 2-4 weeks until I receive the installation kit.

Can I install the trial edition and update-it to standard edition after I...

Application Name is just an attribute that is part of the Connection String to SQL Server protocol which identifies the application that is connected to...

I think an easy options is to Pivot using the UNPIVOT statement

This will transpose your Account1, Account2 columns into one column called "AccountType", then you can do a join on...

venkat.2829 (10/11/2012)

---

I am reading below XML through T-SQL query, please see below and suggest me the solution

DECLARE @xmlAttributeRelation XML

SET @xmlAttributeRelation='<Entity>

...

I...

Quoting from the article:

"Up until the version of SMO that comes with SQL Server 2008 R2, the Size property of an instance of the DataFile...

emile.milne (10/8/2012)

---

Hi I have a tempdb that is 45gb in size. When I go to shrink db it says there is 99% free.

When I go to shrink file,( I have...

Sean - I think the OUTPUT clause will return the rows, there is no SELECT.

blakmk - I think if you wrap up your transaction in a BEGIN and COMMIT, you...

What happens if you force your query to use a particular index?

Have you tried with a fully qualified server name?

Something like <servername>.<localnetwork>.<tld>

Am not sure about your particular business requirements, but I can imagine this setup will be slower since you are introducing a new layer in your architecture, and also I...

Hey,

I would recommend checking your EventViewer to see exactly why the instance is failing to start.

Here is a wee article[/url] that might help you diagnose the problem

If you post up...

I've never tried this before, but you could potentially look at some of the sample code from Microsoft about how to load an RDLC from a Stream:

http://archive.msdn.microsoft.com/reportviewer

Me too, great article for DAX beginners, particularly since it directly compares SQL format to DAX.

I would love to see some cross...

I wonder if you can standardize this and ship it through something like CodePlex maybe as a 3rd party application.

I use a maintenance DB on all instances too, mostly to...