Viewing 15 posts - 27,196 through 27,210 (of 59,102 total)
One very effective approach would be to "partition" the table but that's only if you have the Enterprise Edition and, IIRC, if you don't mind the "archive" being in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2013 at 7:56 am
schleep (3/19/2013)
IF OBJECT_ID('MyTable') IS NOT NULL
DROP TABLE MyTable
GO
SELECT * INTO MyTable
FROM (VALUES(1,19), (2,90), (3,20), (4,8), (5, 9)) AS M(ID, VALUE)
GO
SELECTm.Id, SUM(m2.Value)
FROMMytable m
JOINMytablem2ON m2.ID <=...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 19, 2013 at 7:36 am
beginner_dk (3/18/2013)
the company or the recruiter is unaware of the questions and the answers. He will just receive the score card with the percentile of the candidate.
That's actually a major...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 11:06 pm
Which company asked these as interview questions?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 9:18 pm
alan.hollis 1097 (1/14/2013)
I've been brought on board to help a company start to build their first business intelligence setup. I'm a developer by trade, and have good knowledge of...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 9:12 pm
Whoa!!! Who said anything about the OP storing the VALUE as a character based data type??? :blink:
@Masoud,
Take a gander at the article at the first link in my signature...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 8:57 pm
Evil Kraig F (3/18/2013)
Alright, let's start with the basics. You said you've read up on it but some...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 8:45 pm
beginner_dk (3/18/2013)
these are an online assessment test questions called proveit
Yowch! You should alert the company that made you go through the "Proveit" gambit and then show them Gail's...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 8:37 pm
inHouseDBA (3/18/2013)
Anyone else?
Yes. You didn't mention what you're doing to reestablish the log chain after you break it by setting the DB to SIMPLE recovery mode. I'm just...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 6:06 pm
runal_jagtap (3/18/2013)
We have a DB which have loads of data & we want to archiev it to some Server in such a way that
Scenario - Source DB have...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 5:56 pm
runal_jagtap (3/18/2013)
4 View ... 0 replies :w00t:
14 minutes... broad subject. Need more patience. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 5:51 pm
SqlServerLover (3/18/2013)
Thanks SSCrazy. Union all does not work in my case as i do not want two rows .........but left join worked.. thanks.
Since you said there was no fixed key...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 5:49 pm
Evil Kraig F (3/18/2013)
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
Hi, My name...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 5:35 pm
bitbucket-25253 (3/18/2013)
My one hundreth QOD has...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 5:30 pm
Your post is a bit confusing. According to what you posted, the "Child ID 10" is actually in a column called "[Time Completed]".
Take a look at the first link...
--Jeff Moden
Change is inevitable... Change for the better is not.
March 18, 2013 at 4:56 pm
Viewing 15 posts - 27,196 through 27,210 (of 59,102 total)