Minimal Downtime Storage Migration of Large Databases
This article shows how we were able to migrate a TB size database to new storage with minimal downtime.
2021-02-24
2,386 reads
Microsoft SQL Server
Learning SQL Server
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
2021-02-24
Implementation of Normalization in SQL Server
Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
2,560 reads
Power Query or SQL Server? Which, when and why
When it comes to developing a Power BI report, we can use it for accessing data, transforming the data, and turning the data into information using visuals. With no doubt Power BI can do the job from beginning to end. Now, this is not the only, nor necessarily the best, tool for all the steps […]
2021-01-25
4,973 reads
Execute on DMVs without user having View Server State
Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]
2020-09-24
584 reads
Blogs
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Daily Coping 3 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Disabling Non-Clustered Indexes For Fun and Profit
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
Forums
How to update table partwithcompany column name company id by companyid for max
How to update table partwithcompany column name company id by companyid for max partid...
Appttime add with duration how to get endtime please
Hoe to get appt_time+duration = end_time can you please help on this
SQL Sever becoming Non Responsive
SQL server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....
Ask SSC