Quick thought, check out this excellent article How to Import Data from HTML pages[/url] by Phil Factor

😎

Quick thought, the histograms represents information on data distribution and frequency, the optimizer preserves what it regards as the most useful of those and reduces the number of buckets (steps)...

Quick thought, this is an SSMS flaw when changing a table in design view, a workaround would be using DDL statements (ALTER TABLE) instead of the design view.

😎

First some quick questions

1) Data sizes?

2) Available high performance storage space?

3) Type of storage available?

Suggest using a staging area on the target Sql Server and replace the Lookup transformation with...

balasundar.sp (10/8/2014)

---

Hi,

I have the open, close, high & low prices in a table. These are 0 minutes data, Would want to generate 5min, 15 min, 30 min, 60 min, 120min,...

Congratulations or maybe rather re-gratulations 😀

😎

Quick question, in a cmd as an Administrator, do all instances show up when you run a "net start" command?

😎

er.mayankshukla (10/8/2014)

---

Hi All,

I have a log database where I have all the stored procedure for logging to log tables.

There are two databases - Dev and Test , which has stored...

That is so true, just as beauty, ROI is only in the eye of the beholder

😎

This is even more straight forward to do using the row_number function and set the order to select Current first if it exists, here is a quick sample

😎

USE tempdb;

GO

SET NOCOUNT...

Further on the subject, first an example of a user, title and status tables with mandatory constraints and keys.

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

IF OBJECT_ID(N'dbo.TBL_USER') IS NOT NULL DROP TABLE...

Ed Wagner (10/7/2014)

---

Sean Lange (10/7/2014)

---

That has been going on...

Elementary:blush:, add the aliases and a from clause

😎

UPDATE ER

SET ER.LeaveDate = DATEADD(wk,2, FC.enrollDate)

FROM Fatals_CTE FC

INNER JOIN DBO.Enroll ER

ON ER.enrollmentID = FC.t_enrollmentID;

Quick question, why use cross apply when this can be achieved more efficiently with an inner join?

😎

SELECT

AX.id

,AX.name

,MAX(BX.sal) AS sal

FROM...

Quick thought, the filter is only applied in the scope of the sub-query, effectively a cross apply without a filter which will return all rows. Consider this query instead

😎

USE tempdb;

GO

SET...