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...

Had this problem few times in the passed when I needed a dataset from SQL Server in a local Access...

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 SO just checkout this...

Here is a little snippet to play around with, mind you one cannot blindly read the statistics output;-)

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SET_SIZE INT = 1000000;

DECLARE @BUCKET INT =...

Here is a quick demonstration of a dynamic SQL solution, in case there is no option of changing/adding any tables in the database.

😎

USE tempdb;

GO

/* TEST DATA */

CREATE TABLE dbo.Planner(

[Name] [nvarchar](255)...

rodeliorodriguez 26453 (7/26/2014)

---

It is not actually for me and I just want to test if the 2nd option is really better than the first one. Upon running them in the...

A quick thougt, any difference in the select if you add the DISTINCT directive?

😎

Jeff Moden (7/25/2014)

---

Until you get a 5th row. 😉 Then, you'd need to...