Viewing 15 posts - 1 through 15 (of 142 total)
You need to manage the Disk from Azure Portal.
To modify the storage settings, select Configure under Settings. You can modify the disk settings for the drives that were configured during...
October 8, 2021 at 6:26 am
Microsoft has moved away from Service Pack to CU mode The CU (Cumulative Updates) is already going on and will be way forward. MS should work on install updated without...
October 8, 2021 at 5:03 am
Put the duplicate email from Source table into a temporary table:
SELECT DISTINCT COUNT(0), email INTO #email FROM tUSER_NEW GROUP BY email HAVING COUNT(0) > 1
Keep Duplicate Records in another temporary...
April 28, 2020 at 12:04 am
This is a great article as always. Easy to understand and implement. Thanks a lot for sharing the knowledge.
April 27, 2020 at 11:31 pm
I have made a simple process and used the Script as SQL Job to populate the Table for historical as well Reporting purpose.
June 1, 2018 at 6:33 pm
You should use the CASE instead of IF ELSE... This way you can meet your requirement easily. You may try IIF but with limited options....
January 26, 2017 at 11:15 pm
Hi,
This is true that we are still far behind in terms of proper or best usage of technology withing our database services. There are good number of people who looks...
June 9, 2012 at 11:32 pm
You need to write :
Exam 70-432
Microsoft SQL Server 2008, Implementation and Maintenance
Exam 70-450
Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
December 15, 2009 at 6:07 am
This can be a work around like. Yes it can be configured to have replication configured between SQL Server 2000 and SQL Server 2008.
When you replicate between or among different...
December 14, 2009 at 7:57 am
If you are doing a fresh installation then you may be able to use the old uninstalled name. But then old uninstalled name should be present in current installed server.
Once...
December 14, 2009 at 7:29 am
You should first create a Devlopment users group account in your domain, add your developer users to the group as member. Creaye another DBA Group and add the DBA members...
December 14, 2009 at 6:37 am
This will require the build the new server and then apply a copy of current database and then setup up a transaction log shipment process untill both the databases are...
December 14, 2009 at 6:32 am
You may have to write the two exams to become MCITP(MS SQL Database Administrator 2008)
Exam 70-432
Microsoft SQL Server 2008, Implementation and Maintenance
Exam 70-450
Designing, Optimizing and Maintaining a Database Administrative Solution...
December 14, 2009 at 6:21 am
Microsoft provides the Upgrade Advisor which helps you to analyse the process and possible impact of upgrade.
Read more at
http://msdn.microsoft.com/en-us/library/ms144256.aspx
There are various articles published by Microsoft under How-To topics...
December 14, 2009 at 5:57 am
You need to make one Stored Procedure in your database and then call the stored procedure from your application code.
Hope this will help you.
December 14, 2009 at 5:38 am
Viewing 15 posts - 1 through 15 (of 142 total)