Viewing 15 posts - 916 through 930 (of 2,462 total)
Ford Fairlane (10/14/2012)
I still need to add 8 hours to it and then do a time comparision for the last 15 min all within a where clause
Yes i have...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 14, 2012 at 11:08 pm
David McKinney (10/12/2012)
Make sure to remove / change email addresses etc.It's a simple point, but could have horrible consequences if overlooked.
that is part of data masking
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 3:40 am
GilaMonster (10/12/2012)
What do you need me to explain? The index is redundant, it's a subset of an existing index
So you mean to say here that another ( single colum...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 2:52 am
GilaMonster (10/12/2012)
Yes. Statistics updates have no effect whatsoever on the structure, density, fragmentation or layout of an index.
structure and layout of index i can understand but how come density...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 2:08 am
Gail,
Here OP says that statistics are updated still delete can play role here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 1:35 am
kick_12309 (10/11/2012)
do CDC from build server to production server but the problem is with indexes.
Why indexes are problem here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 12:36 am
opc.three (10/11/2012)
Bhuvnesh (10/10/2012)
looping myselfFYI you can use the Topic Options button on the top roght of each forum page to Subscribe to a topic without posting.
thanks
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 12:33 am
i do think narrow index should have lesser logical reads
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 11:57 pm
rohaandba (10/11/2012)
As mentioned this Trigger doen't not allow developers with DDL-Admin permissions and Db Owner permissions to make any DDL changes to the Databases
HOw have you restricted the user to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 11:38 pm
use select getutctime() , it will give you GST time then use select dateadd() function to get required reuslt
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 11:35 pm
you can use sql profiler
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 4:54 am
use this
ALTER DATABASE [DatabaseName] MODIFY FILE ( NAME = N'DATABASENAME_Log', SIZE = 512000KB , FILEGROWTH = 0)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 3:01 am
Senthil Kumar Rajendran (10/11/2012)
its showing SQL server(MSSQLSERVER) but in stopped state.
why they are stopped ?
Senthil Kumar Rajendran (10/11/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 1:56 am
there could be some hardware allocation differnce like memory or cpu OR sme diiferent setting like maxdop etc
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 1:46 am
PradeepVallabh (10/4/2012)
i m not sure where else this index is being used....Does modifying this index by including a column, changes the performance of other queries
you can use sys.dm_dp_index_usage_stats dmv...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 11, 2012 at 12:22 am
Viewing 15 posts - 916 through 930 (of 2,462 total)