Viewing 15 posts - 631 through 645 (of 3,060 total)
bijarcity (1/2/2012)
i have a question !is your data static it means how you match your data in both servers?
If the first part of the question question is: "What static data...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 2, 2012 at 9:58 am
kavyap.kp (12/30/2011)
ryt now i have a student table with student details a lecturer table and a course table,,,,,,,,,,,,
Well... if you have the tables that means that you already have a...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 2, 2012 at 9:36 am
bijarcity (1/2/2012)
i have 2 computers and i installed sql server on them.i have a same data in the two sqlservers.
i have a...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 2, 2012 at 9:33 am
ychen1214 (12/31/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 2, 2012 at 9:27 am
How about differential backups? if the issue is space the size of differential backups will follow the volume of data that actually changed on those particular databases.
For these low...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 2:35 pm
How to: Check the ODBC SQL Server Driver Version (Windows)
SQL Server 2008 R2
Your computer may contain a variety of ODBC drivers, from Microsoft and from other companies. Use the Windows...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 2:11 pm
kavyap.kp (12/30/2011)
...is there a solution for it?
Yes, I think so - what do you think?
Why don't you start by showing us your ER model?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 12:45 pm
Dev (12/30/2011)
PaulB-TheOneAndOnly (12/30/2011)
jr.sqldba (12/30/2011)
I have created database and enter the values in to that table.
and also perform the explicit transaction after that in another window i wrote the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 8:51 am
WangcChiKaBastar (12/30/2011)
but when we run the same query on SSMS its fine.
I ran profiler but didnt get much clue, Tlog is OK...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 8:45 am
Saggy (12/30/2011)
How to migrate sql server database and all system databases from one server to another server?
Adding on Perry's comment.
Is this a plain "migration" as in hardware refresh, no SQL...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 8:39 am
jr.sqldba (12/30/2011)
I have created database and enter the values in to that table.
and also perform the explicit transaction after that in another window i wrote the below steps
SHUTDOWN WITH NOWAIT;
GO
but...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 7:23 am
Gianluca Sartori (12/30/2011)
PaulB-TheOneAndOnly (12/29/2011)
pandeesh (12/29/2011)
Any other suggestions welcome...
How about using coalesce?
create table #test(id decimal);
insert into #test values(1);
insert into #test values(2);
insert into #test values(3);
insert into #test values(4);
insert into #test values(5);
insert into...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 30, 2011 at 7:17 am
how about replacing:
over (partition by account_number order by end_date asc )
by:
top 1 over (partition by account_number order by end_date desc)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 29, 2011 at 1:40 pm
I remember having to do it a few years ago.
Didn't use a third party tool but a set of three stored procedures: sp_hexadecimal, sp_help_revlogin and a sligthly hacked version of...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 29, 2011 at 1:13 pm
David Moutray (12/29/2011)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 29, 2011 at 12:01 pm
Viewing 15 posts - 631 through 645 (of 3,060 total)