Duplicate post, answers in the other thread please!

😎

scarydba (7/21/2014)

---

I am trying to upgrade SQL 2000 reporting services to SQL 2008. I backed up the ReportSever and ReportServer TempDB and restored successfully, However when I try to restore...

It is better to break down the problem into smaller parts using nested case statements, more readable and easier to follow. Here is an example which should be close to...

previn1980 (7/26/2014)

---

Sorry if I do not understand.

So, SSDT is an integrated CLIENT tool in Visual Studio which replaces BIDS for develops etl packages/processes. Is it right?

If so, what's the...

GilaMonster (7/26/2014)

---

Before you apply compression to everything, test and make sure that the CPU overhead is acceptable. On page compression it can get nasty. Also don't compress indexes unless you...

Didn't take long :blush:

Thanks!!!

😎

previn1980 (7/26/2014)

---

Eirikur Eiriksson (7/26/2014)

---

First of all, welcome to the forum. SQL Server 2012 has a new approach to the Business Intelligence via the Data Tools, look for SSDT instead of...

previn1980 (7/26/2014)

---

Hi to all

I want use for practice and learning purpose the SQL Server Integration Services ETL tool and Business Intelligence Developement Studio to builds/develop packages/etl processes.

What I want ask...

Lynn Pettis (7/26/2014)

---

I'm going to say it depends. When first starting to work with one, almost necessary to get a feel for the recruiter and the company. Sometimes...

smtzac (7/26/2014)

---

I have a huge database 600+ GB and it is TDE enabled. I want to make database smaller. I found some tables are more than 1 million rows and...

Here is a very efficient Window Function method, one scan of each table.

😎

USE tempdb;

GO

DECLARE @Employee TABLE (EmployeeID INT, EmployeeName VARCHAR (100), EmployeeDOB DATE)

INSERT @Employee VALUES (101, 'James Bond', '07/07/1945'), (102,...

Duplicate post, answer to this one please.

😎

10 minutes preparing the data sample, 1 minute writing the...

Here is a Window function running total example, performs quite nicely;-)

😎

USE tempdb;

GO

create table #current(acctNum int,

dates date,

transtype char(10),

amt INT

)

insert into #current(acctNum, dates, transtype, amt)

values (11,'7/1/2014','debit',1),

(11,'7/2/2014','debit',3),

(12,'7/3/2014','credit',5)

create table #balance (acctNum int,

AsOfDate date,

balance INT

)

insert...

Koen Verbeeck (7/26/2014)

---

Eirikur Eiriksson (7/26/2014)

---

Koen Verbeeck (7/26/2014)

---

Sean Lange (7/25/2014)

---

Eirikur Eiriksson (7/25/2014)

---

Sean Lange (7/25/2014)

---

Eirikur Eiriksson (7/25/2014)

---

Jeff Moden (7/25/2014)

---

Sean Lange (7/25/2014)

---

WOW!!! If you have ever wondered about the quality of responses at...