Viewing 15 posts - 16 through 30 (of 92 total)
Found nice article
Got it.
Thank You
January 27, 2017 at 5:08 pm
I have 2 databases in my production server(Server A):Production and copy of Production database(Prd_Copy.).Every day i am restoring previous day's full backup of production database into Prd_Copy..bak file resides in...
September 8, 2016 at 1:47 pm
Thank you guys.And differently i'll use Tsql .
February 5, 2016 at 10:27 am
No.I am trying to configure Database Mirroring(SQL Server 2014)
February 4, 2016 at 6:07 pm
Sorry for inconvenience.next time i'll make sure to post sample data.And thank you for your replies
October 8, 2015 at 12:08 pm
I have a task similar to this one.
i have client table which has client_id Eff_from and Eff_to columns.Eff_from and Eff_to are the dates that client is eligible for service.I need...
October 8, 2015 at 11:18 am
tnx for reply.lets say i have 5 columns and col1 is clustered(not identity).I insert values 10,x,x,x,x .How do i get cluster index key value ?
My assumption was that it is...
September 25, 2015 at 9:46 am
i got it.Just added COUNT(*) to Luis's script.Thank you guys
September 11, 2015 at 12:57 pm
Sorry if i was not clear.This is wat i want to see in my results;
BLOCK STREET CITY NoMatchTotal TOTAL
Luis's script is what...
September 11, 2015 at 12:48 pm
Here is my test results:
if i run from MyDB it executes sp_XYZ that is in MyDB
if i run from master it executes sp_XYZ that is in master
if i run from...
August 31, 2015 at 7:16 pm
just keep in mind that updating statistics causes queries to recompile.There is a performance tradeoff between improving query plans and the time it takes to recompile queries
June 23, 2015 at 4:13 pm
...Col1 will have value that application will generate(id)....
It is not some random number.There is some logic involved .
thank you all for your replies
June 9, 2015 at 10:28 am
Viewing 15 posts - 16 through 30 (of 92 total)