Easiest question ever for 7 point 😀

Mark Grout (8/23/2013)

---

Four Points! Yay!

I understood this question not at all. but I figured the correct answer had to be number two of five, the one above "this can never...

Why not use DateName function instead of using case conditions !!, as the datatype of column you are checking is datetime.

Thanks for your suggestions and reply,

Even I did the same recover the connection and replication did the job itself, I was just curious whether we have such options available or...

You can create a trigger on Table A and update the Table B directly, why to create Table C just for later joining it with TableB.

Whenever you fire same query second time or more, it will be faster anyways as it will pick the result from cache and gives faster results. This may be the...

Primary Key Violation error mince.. you are trying to insert duplicate rows into table.

SQL Server can sort integer data...

IF EXISTS (SELECT 1 FROM sysarticles WHERE name = @vArticle)

PRINT 'WARNING: Article= '...

try adding article using below query.

EXEC sp_addarticle @publication = 'PublicationName', @article = 'articleName', @source_object = 'articleName', @source_owner = 'dbo', @Type = 'view schema only'

GO

EXEC sp_refreshsubscriptions 'PublicationName'

GO

Normally on a...

Dont think changing datatype will have any significant performance change, unless these columns are used in where clause or filteration purpose, if yes create a index on it and then...

It may be the case of parameter sniffing, alter procedure with WITH RECOMPILE and try.

Try this...

DECLARE @TestTb TABLE

(eid int, [date] date, [time] time, status char(3))

INSERT INTO @TestTb (eid, [date], [time], status) VALUES

(26359,'2013-01-01','07:44','IN'),

(26359,'2013-01-01','18:50','OUT'),

(26359,'2013-01-02','07:47','IN'),

(26359,'2013-01-02','18:51','OUT')

SELECT * from @TestTb

SELECT a.eid, a.date, d.InTime, e.OutTime

FROM

(SELECT DISTINCT eid, date FROM...

whenever you create a database with multiple data files, the first file will be created as .mdf and all other as .ndf.

Normally we create database with multiple data files...

Becuase your query fires INNER JOIN between all three tables, So as per the test data, it will check for all Data available in all three tables.

For Example

First...