SQL Server DBA
SQL Server DBA. Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis,powershell.
Read Sqlserver-dba.com news digest here: view the latest SQL Server DBA articles and content updates right away or get to their most visited pages. Sqlserver-dba.com is not yet rated by Alexa. It seems that SQL Server DBA content is notably popular in USA, as 9.9% of all users (8.7K visits per month) come from this country. We haven’t detected security issues or inappropriate content on Sqlserver-dba.com and thus you can safely use it. Sqlserver-dba.com is hosted with CloudFlare, Inc. (United States) and its basic language is English.
- Content verdict: Safe
- Website availability: Live
- Language: English
- Last check:
-
2 932
Visitors daily -
2 932
Pageviews daily -
2
Google PR -
N/A
Alexa rank
Best pages on Sqlserver-dba.com
-
Calculate sql row size (SQL Server DBA)
Question: How can I calculate the sql row size? Answer: Calculating the row-level row size is complicated and challenging. One of the key problems is SQL Server defines space at the extent level . An ...
-
SQL Server performance tuning expert . SQL Server DBA
-
SQL Server RUNNABLE – SUSPENDED – RUNNING status model
Question: When I’m viewing activity on SQL Server , for example, sp_who2 – the status column displays different states – RUNNABLE – SUSPENDED – RUNNING. Could you explain the difference? Answer: Some ...
Sqlserver-dba.com news digest
-
7 years
Troubleshooting SQL Server Service Broker
If you’re not experienced in all the nuances of Service Broker, it can be tricky to diagnose or identify if there is an issue with Service Broker.
There are plenty of products using Service Broker. SCCM is an example .
Here are some queries I use when needing to troubleshoot SQL Server Service Broker.... -
7 years
Using wait stats to identify pressure points on your SQL Server is a common method for troubleshooting. Unfortunately , it is very easy to jump to conclusions about problems on the basis of the highest wait stats.
My general approach is to use wait stats , but letting them guide me to extra analysis. There could be all sorts of reasons why a wait stat or a combination of wait stats appear .... -
7 years
SQL Service hanging with Change Pending Error
Here’s a strange error I experienced when attempting to restart a SQL Server Service. The Service wouldn’t restart , the status was hanging on “Change Pending”.
I’d seen this error before, but during installations. I hadn’t seen it when the service was established. I checked the SQL Server Error logs – which I had to access directly via the file system and read as a palin text file, as I couldn’t access SQL... -
8 years
Msg 8116 - Argument data type sql_variant is invalid for argument 1 of function
A colleague presented me with the Msg 8116 - Argument data type sql_variant is invalid for argument 1 of function error message when creating a new sql script.
The Msg 8116 error message was generated by executing this code:
select reverse(serverproperty('machinename'))...
Domain history
Web host: | CloudFlare, Inc. |
Registrar: | CSL Computer Service Langenbach GmbH d/b/a joker.com |
Registrant: | Jack Vamvas (Ciquery Ltd) |
Updated: | June 30, 2017 |
Expires: | June 30, 2018 |
Created: | June 30, 2010 |
Whois record
Visitor gender
Male
Female
Safety scores
Trustworthiness
N/AChild safety
N/A