pawana.paul (9/19/2014)

---

Hello,

I altered index with maxdop to somevalue (n). What is the query to validate that xyz index has maxdop value set to (n)?

I tried with GUI. index properties, option...

As far as I've seen, the retention issues are not the platform itself but the dependants. The technical part of the SQL Server upgrade is one of the smoothest there...

Not certain what you are indeed asking but a short list...

There are few ways of doing this, here are two of them. The first uses a combination of GROUP BY and HAVING, the second uses ROW_NUMBER and MIN/MAX Window function.

😎

USE...

Here is a suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_DATA TABLE

(

CallStartDateTime DATE ...

Luis Cazares (9/18/2014)

---

I tested it on sqlfiddle.com and...

Oops, used the wrong code:-P Here is the correct version, in fact the same thing Luis posted, but in SQLite dialect

😎

select

1 AS Group_ID

...

naga.rohitkumar (9/18/2014)

---

How can we move the data from one table to another table in diff server

server 1 have 5 million records and it need to move to server 2 table...

You're welcome;-)

Quick question, would you ever have more than two rows for a subject (CanNum)?

😎

Here is a simple solution which uses charindex for the matching and a combination of len and replace to count the expected number of matches, should be enough to get...

Quick self-join type solution

😎

create table #temp(candId int identity(1,1),CanNum int,name varchar(50),Attempt1 int,Attempt2 int,attempt3 int)

insert into #temp values ( 1001, 'Abhas', 120, 150, 180)

insert into #temp values (1002, 'John', 150, 150, 180)

insert...

Here are two snips, should help get you passed this hurdle

😎

Snip 1, using logical operators instead of a case statement, works in SQLite but not in TSQL

select

...

I've had similar issues when working on servers in DMZ or other network restricted "areas", sometimes adding a host record or an cliconfg alias has helped but not always.

😎

Thanks Shiva for an amusing question.

I like the simplicity of the brute force approach although of course it doesn't scale beyond 3 digits. The only criticism I have is...

Quick thought, when the IS is not working, try pressing CTRL+SHIFT+R to refresh the cache, also check the Tools-Options-Text Editor-Transact SQL-IntelliSense memory settings, might want to increase that.

😎