Does Join Order Matter?
According to Conor Cunningham, it doesn’t.
I have heard that there are issues in the optimizer, and to be sure, there...
2010-08-31
1,829 reads
Blog Posts
How to fix Orphaned Users
To view if there are any orphaned users, run this query against the DB;
sp_change_users_login ‘report’
To fix;
sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’
2010-08-31
1,887 reads
Interview with SQL Server MVP Glenn Berry
This is a first of a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL Server Connections...
2010-08-31
2,506 reads
Maintenance Plan "No description found" error
for Sql server 2005, It was a bug when you modify maintainance plan you may get the error “no description...
2010-08-31
2,767 reads
Positioning SQLRally in the PASS Event Universe
Prior to creating SQLRally the world of PASS consisted of the PASS Summit which is our annual mega-event, the European...
2010-08-31
1,830 reads
Project Phoenix: Late August Awards Announced
Two more eligible developers and deserving projects have been selected. Any proposals submitted but not selected this time will be...
2010-08-31
1,484 reads
Replication Gotcha - Including An Article In Multiple Publications
When administering replication topologies it's common to group articles into publications based on roles that subscribers fulfill. Often you'll have...
2010-08-31
10,656 reads
Return top 20 queries by Average CPU
I’ve recently used this when troubleshooting some unexplained high CPU load on my server:
select top 20st.objectid, st.dbid, total_worker_time/execution_count AS AverageCPUTime,CASE statement_end_offsetWHEN -1...
2010-08-31
4,241 reads
SELECT, Deconstructed
Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing...
2010-08-31
2,561 reads
SQL Saturday #48 - Columbia - Call for Speakers Ending
This is a reminder for those who might be considering submitting a session but haven't yet. The call for speakers...
2010-08-31
1,403 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers