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
4 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
2 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
1,009 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
17 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
28 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
3,312 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
9 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
5 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,631 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
4 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers