Viewing 15 posts - 271 through 285 (of 2,462 total)
Addtionally why are you using row_number() over(partition by col1,col3 order by col3) as rownumber
if you are not using it ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2013 at 4:14 am
Where/what is the question ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2013 at 4:11 am
can you provide the sample data to which is being in used in above queries
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2013 at 12:44 am
My first question is Why you need this ? means updatign the ID column with ExtendedID
Second,whatever the reason , there are very much chances that you wil get PK...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 13, 2013 at 11:47 pm
Either use CASE statement with LEFT JOIN
or
EXISTS clause
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 13, 2013 at 11:44 pm
mah_j (3/12/2013)
Is there any way to have more less down time for example some thing like redefinition in Oracle that...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2013 at 11:07 pm
JP-1019544 (3/11/2013)
Think it SOLVED my problem.
How ? what changes you made ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2013 at 12:06 am
GilaMonster (3/11/2013)
Bhuvnesh (3/11/2013)
1) There could be less data in that range....
but i still vote the first reason.
How could there be less data between '2013-01-01' and '2013-01-31' than there is between...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2013 at 5:27 am
Model database is used by Tempdb during restart . and that could be the why sql server didnt get re-start
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2013 at 5:16 am
mah_j (3/11/2013)
Can I use MaxDop = Number of processors in main server?
yes you can try is it but first at test server and see how uch benefit you...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2013 at 5:06 am
JP-1019544 (3/11/2013)
I'm executing the below TSQL on a table with about 700,000 records. I am clearing the caching so it does not affect the queries.
When the data range is between...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 11, 2013 at 5:02 am
Grant Fritchey (1/31/2013)
Get a copy of SQL Server 2008 Internals by Kalen Delaney. Then read it 100 times. You'll still be confused (as I am) but less so.
Grant, i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 8, 2013 at 3:33 am
vineet_dubey1975 (3/7/2013)
My both the DBS are on same file filegroup e.g. PRIMARY.
Refer the link i posted above
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 4:06 am
Also manage the permisson of users. Restrict the poeple from unauthoirized access. if possible or required, log the audit login plus DDL commands
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 1:05 am
vineet_dubey1975 (3/6/2013)[hr
Can i move 'TBLHistory' to HistoryDB and still i can perform switch out and Switch in?
Note:Both DBs are residing on same instance of the server.
NO . for switch-in...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 7, 2013 at 1:00 am
Viewing 15 posts - 271 through 285 (of 2,462 total)