If you haven’t heard, SSMS v18 went GA (Generally Availability) recently. You can download it from Microsoft, though if you have a preview version, you do need to uninstall...
2019-05-17 (first published: 2019-05-06)
586 reads
This weekend I was in Stockholm in Sweden, talking Query Store and plan forcing with Steinar Anderson, when he mentioned the problems he had while forcing plans that had...
2019-05-06
175 reads
SQL Server Enterprise Edition can leverage large memory pages to reduce the amount of memory pointers required for larger SQL Server deployments. Reducing the number of pointers makes the...
2019-05-20 (first published: 2019-05-06)
519 reads
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner ... Continue reading
2019-05-22 (first published: 2019-05-06)
560 reads
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-06
30 reads
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-06
64 reads
In my last blog post I showed that using the SSIS Provider could be an easier option for deploying an .ISPAC file, vs. the PowerShell script method shown in...
2019-05-21 (first published: 2019-05-06)
1,012 reads
Microsoft SQL server database contains the most crucial data of organizations. But while using MS SQL server many users often face problems like abrupt termination, database connection errors, transient...
2019-05-06
18 reads
Microsoft SQL server database contains the most crucial data of organizations. But while using MS SQL server many users often face problems like abrupt termination, database connection errors, transient...
2019-05-06
68 reads
SQLDay starts in a week! Stay tuned during this week as it could be full of surprises! We are ready & prepared and speakers start to arrive next Saturday!...
2019-05-05
31 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Too Many Choices
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers