wisdom-soup.com
DBA Scripts | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/dba-scripts
Share SQL Server Tips and Tricks and Related News. Category Archives: DBA Scripts. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. And tagged cpu pressure.
wisdom-soup.com
Troubleshooting | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/troubleshooting
Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...
wisdom-soup.com
SQL Server Security | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/sql-server-security
Share SQL Server Tips and Tricks and Related News. Category Archives: SQL Server Security. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. To obtain the mirroring endpoint name.
wisdom-soup.com
Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission | Wisdom-Soup
http://www.wisdom-soup.com/blog/troubleshooting/unable-drop-windows-login-sql-server-due-endpoint-permission
Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...
ignaciosalom.com
brent ozar – IgnacioSalom.com
https://ignaciosalom.com/tag/brent-ozar
Posts about SQL Server and other technology subjects. I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com. SQL DBA Essential Links. Join 13 other followers. Have you checked your SQL Server CPU speed lately? Blog at Wo...
ignaciosalom.com
SQL Server 2008 performance dashboard and SQL Server 2012 performance dashboard – IgnacioSalom.com
https://ignaciosalom.com/2013/02/12/sql-server-2008-performance-dashboard-and-sql-server-2012-performance-dashboard
Posts about SQL Server and other technology subjects. I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com. SQL DBA Essential Links. Join 13 other followers. And http:/ sqlserverfinebuild.codeplex.com/wikipage? Fill in ...
ignaciosalom.com
cpu speed – IgnacioSalom.com
https://ignaciosalom.com/tag/cpu-speed
Posts about SQL Server and other technology subjects. I was born in Barranquilla, Colombia in 1975. When I was 17 I moved to Curacao where I lived 10 years and then move to The Hague, The Netherlands. I speak 4 languages (Dutch, English, Papiamento and Spanish). I hope you enjoy my blog and if you want to send a question, just drop me a mail at ignacio.salom@cenlinea.com or ignacio@ccgroep.com. SQL DBA Essential Links. Join 13 other followers. Have you checked your SQL Server CPU speed lately?
mcdbadirectory.com
MCDBA Newsletters and SQL Server Newsletters
http://www.mcdbadirectory.com/newsletters.htm
MCDBA Directory - YOUR Microsoft MCDBA certification and training connection! YOUR certification journey begins with a single step at MCDBA Directory. MCDBA Newsletters and SQL Server Newsletters. Newsletters and online ezines are filled with MCDBA certification tips and Microsoft SQL Server product information that will be useful in studying for the MCDBA certification exams. FREE newsletter published twice each month. FREE email newsletters on various Microsoft certifications.
thesqlwizard.blogspot.com
The SQL Wizard: I still love hockey.... and Oracle!
http://thesqlwizard.blogspot.com/2008/09/i-still-love-hockey-and-oracle.html
Wednesday, September 17, 2008. I still love hockey. and Oracle! As a follow up to my last post, here is an extremely simple way to show each player's salary percentile ranking using Oracle. A table named SALARIES contains the player's salaries:. Crosby, Sidney 8700000.00. Gonchar, Sergei 5000000.00. Fleury, Marc-Andre 5000000.00. Whitney, Ryan 4000000.00. Malkin, Evgeni 3834000.00. Orpik, Brooks 3750000.00. Satan, Miroslav 3500000.00. Sykora, Petr 2625000.00. Sydor, Darryl 2500000.00. And the results are.
SOCIAL ENGAGEMENT