Palm (in today's weather, I'm wishing for palm trees)

Popcorn

Well, this morning is a beautiful day. The mercury tips in at -13 F with the wind chill at -39 F. A new record for Southeast Michigan. ...

When you're connected to the FTP server, you can change directory using cd, just like in Windows. You'll probably want to use the forward slash, but that's not true...

And here I was looking forward to the high-velocity pork chop firing squad. 😀

You can calculate the date that is 7 days before today, but that won't help you limit your query results because you don't have a date field to compare it...

Sridhar-137443 (1/6/2014)

---

Hi, we have a history table in our system that we insert records into it once every 2 weeks but we query the table almost every day. So, we...

Time

Jeff Moden (1/6/2014)

---

elham_azizi_62 (1/6/2014)

---

thanks for your reply.I create this sp with your query:

ALTER procedure [dbo].[icanSP_Convert_GetEntityDependencies]

@DocId INT,@Count int

as

begin

;WITH MyTable AS (

SELECT * FROM (select linknumber,savabegh from main2 where savabegh is not...

I think I'd have to vote for the 270-column table where the upload is not working properly. It made me smile and...

Chariot

Good way to start the week. Thanks, Steve.

Jeff Moden (1/3/2014)

---

We really dodged the bullet with the "Hercules" snowstorm than nailed New England. We only got about 6 inches here about 20 miles north of Detroit.

That's about...

Better yet, Gail has written a great place to start with indexes.

http://www.sqlservercentral.com/articles/Indexing/68439/

http://www.sqlservercentral.com/articles/Indexing/68563/

HTH

For this table, it is fine if you add a column as IDENTITY (1, 1) and define it as a primary key. It'll be a 4-byte key.

It appears that...