Designing your tables with PKs is a best practice.

You should not have PKs only for staging tables.

This article is very good - http://www.mssqltips.com/sqlservertip/1254/clustered-tables-vs-heap-tables/

From your questions, it seems the #TMP table is causing the slowing down.

Is it indexed by ID?

You can create indexes on #temp tables.

SELECT

{ [Project].[Project Phase].Members, Project.Cost.Cost } ON COLUMNS,

NON EMPTY

{ [Project].[Department].Children, [Date].[Month].[Month] } ON ROWS

FROM theCube

Nice question, thanks!

Grant Fritchey (4/27/2015)

---

Yeah. I'm unclear on...

You can use the NOLOCK hint for srno without worries because u're reading an identity value.

Ok,

If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.

where Lotno=@Lotno

...

Are you updating those 60K rows one by one?

If so than it's expected to be slow. You have to run a set-based update query.

That is not a big table, regardless of the 200 million rows. It's size isn't bigger than 5GB. You'd better do the copy in batches of let's say 1 million...

Hi

If you proceed with the upgrade, it will make a backup of the old version into a Backup folder of the solution.

Why do you need it? It's a certification for SQL Server 2008. I wonder if you can do it still.

You'd better switch on 70-461,70-462,...

Check up what shpaghettidba suggested to, and you can additionally use the REPLACE() function to replace those non-visible characters (usually char(9), char(10) and char(13)) with whitespaces and then TRIM them.

Great Question Carlo, thanks!

Hi,

You have to use dynamically created query and execute it. The query should have @date_from and @date_to. Because you have to get data from CUBE (am I am right?), the...

sharonsql2013 (4/21/2015)

---

Whats the best way to put this in 3 different columns ?

Select DATEPART(WW,GETDATE()) - 1 as Lastweek

Select DATEPART(WW,GETDATE()) - 2 as LastWeek1

Select DATEPART(WW,GETDATE())...