SQL DBA Guru
USE <>;
GO
WHILE (SELECT AVG(ListPrice) FROM Production.Product) < 300
BEGIN
UPDATE Production.Product
SET ListPrice = ListPrice * 2
SELECT MAX(ListPrice) FROM Production.Product
IF (SELECT MAX(ListPrice) FROM Production.Product) > $500
BREAK
ELSE
CONTINUE
END
I am talking ABOUT …
Dear Karthikeya,
First of all, thanks for putting up your query here. I would like to know if you have any prior database or SQL Server related knowledge and experience. If yes, I would guess it would be upto a beginner's level. Before we can proceed, I would suggest you to kindly go throu…
Hello Sir,
This salary calculator is amazing and I am very much excited after knowing the great potential in my career as a SQL Server DBA. Currently, working in a MNC in Management team but after reading your blogs and motivating articles, I am planning to move towards SQL DBA as my career. Pleas…
Hi Neha,
Answering Comment#13, the command for taking a transaction log backup is as follows.
BACKUP LOG <>
TO DISK = 'C:\DatabaseName.TRN'
WITH STATS
GO
Please replace the <> with the actual database name for which you are taking the backup.
Regarding Comment #14, it seems that y…
Hii Sir,
Can you please tell me what the above query is doing(Output).
Thanks.
Please tell me in detail how to create a transaction log backup??
--------
Neha Sharma
http://tivlabs.in/
Hello,
This blog site is just awesome coz when you are in trouble related to SQL Server you must post your query here,its amazing u'll get reply with best solution for your query.
I am really very much thankful to Mr.sujeet Sir for his kind and motivative response he saved me to get my degree.
Tha…
Dear Bikas,
For answering comment# 10, thanks for your kind words and I am happy that you liked the articles and knowledge sharing in this website. For your certification, I would suggest you to go through the URL - http://sqldbaguru.com/dba-without-prior-experience in my website. Please feel f…
Hi Neha,
Answering to comment# 8, please check the "Articles" section in my website - www.SqlDbaGuru.com, which explains you how to setup and configure the database mirroring. Do let me know for any additional queries.
Here is an example for your while loop. I hope this solves your problem.
USE
Hello Sujeet Sir,
I have gone through your blog and website - www.SqlDbaGuru.com and got your email ID from there.
First of all, thank you for being so selflessly giving person, you are one of those rare kind.
Now about me, I am a .NET developer with 4 yr of experience from kolkata, INDIA but will…
Hi Sujeet,
I am working on a project named "SQL Server 2008-R2 Security features". I have completed the documentation part to describe the SQL Server 2008 R2 Security features in comparison to MySQL.
But now I have to implement something and have to show that SQL Server 2008 R2 is more secure, …
Dear Neha,
Thanks for putting up your question at SqlDbaGuru.com and I am more than happy to answer your query. But can you explain a bit more on the question? Do you want to know how SQL Server 2008 R2 is more powerful and secure than SQL Server previous editions?
Do you want to know th…
Need Help Urgent.....
Dear Sir,
I want to measure the values in to two databases(SQL Server 2008-R2 and SQL Server Lower versions/MySQL/Oracle whatever ll be easy can take it doesnt matter) so that i can proove that SQL Server 2008-R2 is more Secure in all respect such as No/minimum Dataloss, relia…
Hi,
This is siva SQLDBA
its good blog keep maintain
Hi Kolla,
Thanks for putting up your question here. Here is the SQL Script to know the fragmentation level of any table and its indexes. Also note that it gives the details about the fragmentation in percentage.
DECLARE @db_id INT;
DECLARE @object_id INT;
SET @db_id = db_id(N'Database Name');
SE…
Dear Suresh,
Thanks for putting up your question here at SQLDBAGuru.com and happy to know that this website has given you enough confidence and thrust for becoming a SQL DBA.
I hope you have gone through all of the related blogs in my website which tells you many things about the pra…
i have 3 batabase with same tables struck.. now i want to show one report with marge 3 batabase..how do i get it?/
i want to take backup of database 3 months before . i am using sql 2000 server. please help me
Need help in knowing the impact if SQL max memory is more than RAM capacity.
Dear Abhinandan,
Thanks for putting up your question here. Let me rephrase your question - Two different people (or users) are using the same user ID and password to login to a SQL Server, assuming the logon credentials have been shared between both the users. If this is the case, SQL Server will…
It's really good & motivating too
If my server received 2 requests to login with same user name and password (Here one who has registered has given his user name & password to some1), then as a DBA what precautions i shall take so that it will be allowed to only one person to log-in & deny the access to other. Using JSP or Servlets.…
Hi Sir,
Its very true & very very encourageous for those who don't know for career path infact everyone.
Personally I congrats you for these types of articles.
pls try more & more which can help others and felt satisfaction to be a human being.
Thanks a lot.
Regards
Ajay Miglani
Dear Ajay,
Thanks for putting up your question here. One of the pre-requisites is you must have administrative rights on the computer to install SQL Server 2005 Service Packs. I personally would suggest first to upgrade it to SQL Server 2005 SP3 and then to SP4.
To upgrade it to SQ…
Hi Raghu,
First of all, I would like to know the Recovery Mode of the msdb database. Please change it to SIMPLE, if it is in other mode.
To check the recovery mode:
SELECT name, databasepropertyex (name,'Recovery') FROM master..sysdatabases
To set the recovery mode to simple:
USE master;
ALT…