SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...
2015-09-24
2 reads
Forrards Group Database Blog
SQL Server Enterprise Edition Advanced Scanning
It is widely known that SQL Server Enterprise Edition contains a range of improvements, which under certain conditions allow you to perform operations in a more optimal way in...
2015-09-24
1 reads
SQL Server 2014: ONLINE operation on a single partition of partitioned object
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...
2015-09-22
928 reads
SQL Server 2014: ONLINE operation on a single partition of partitioned object
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
1 reads
SQL Server 2014: ONLINE operation on a single partition of partitioned object
Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...
2015-09-22
1 reads
Define SQL Server database permissions for development team
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard...
2015-09-14
2,784 reads
Define SQL Server database permissions for development team
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard permissions list and database environment for code writing and...
2015-09-14
1 reads
Define SQL Server database permissions for development team
The dba routine includes developer’s accounts management. Such as creating sql logins for new developers. There is usually a standard permissions list and database environment for code writing and...
2015-09-14
1 reads
SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly....
2015-09-10
1,579 reads
SQL Server 2014: protection against Database Administrator
Such a topic related to SQL Server 2014 CTP1 may seem a bit strange, but it was chosen not randomly. The questions like “How can I protect my data...
2015-09-10
1 reads
Blogs
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Daily Coping 24 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Shared Work Spaces: Hell, Heaven, Both?
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
T-SQL : Slicing time Islands and gaps
Hello, Consider the following table that gives the validity dates of an item :...
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Ask SSC