Viewing 15 posts - 2,341 through 2,355 (of 22,224 total)
Agreed with @NorthernSoul.
If you mean how do you set up administrator privileges, I'd suggest that each instance has a different login than the underlying OS. Least privilege principle should...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 9, 2019 at 11:33 am
Isn’t it a kinda shame to have such queries exposed on a specialised site of SQL Server professionals?
Could we form a group of volunteers who could fix this...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 4, 2019 at 8:17 am
I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 2, 2019 at 3:39 pm
What is the chance of getting an SQL Saturday in Birmingham, AL? There are a lot of us over here
Just gotta find a volunteer to do the organizing and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 1, 2019 at 8:20 pm
Whoa! That sure reads like a bit of a mess. I hope they can straighten it out. I can't say I'm a fan of SE, but I'm not actively opposed...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 1, 2019 at 3:47 pm
What the heck is a FULLZ? Are dead FULLZ better than live FULLZ? Inquiring minds.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 27, 2019 at 1:47 pm
Even if we do a virtual SQLSaturday, I'm positive the local events would continue. While a lot of people want to have big events with a host of international speakers,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 27, 2019 at 1:44 pm
PASS hosts a whole bunch of different virtual events year round, 24 Hours of PASS and the PASS Marathons. Plus there are the virtual chapters that meet...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 27, 2019 at 1:40 pm
Hopefully today was better. That last one is one of my big fears, loosing my keys, along with loosing phone or wallet. Had something similar happen to a friend...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 26, 2019 at 8:17 pm
Don't forget about statistics. The reason to do an index rebuild is, in theory, to reduce fragmentation. However, as a side benefit, you get rebuilt statistics. It's entirely possible that,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 26, 2019 at 12:28 pm
All it takes is one person within your company who is authorized, let's say to see the credit card data, but not the PII of individuals, accidentally, not even on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2019 at 1:47 pm
I don't have an answer to your question, but please let me point out another issue.
You're getting ready to hop the 2014 Cardinality Estimation Engine upgrade gap. The new CE...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2019 at 1:41 pm
SSMS is a separate install, too.
YAY!!!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2019 at 1:35 pm
Do you have a limit on the number of processors in use on the server? You really should, but if it's set to 0, then SQL Server is making the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 25, 2019 at 1:34 pm
I think there's a Stairway series on them here on SSC.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 24, 2019 at 5:11 pm
Viewing 15 posts - 2,341 through 2,355 (of 22,224 total)