SQL Server vNext Performance Windows vs Linux

I installed SQL vNext CTP 1.4 on Windows 2012 R2 and some Linux Machine in order to compare performance. Basically Write Access is compara...

Read More

SQL Doesn't start and Event ID = 17204

After hardening a server, the service didn't start anymore and I found the following error: Event ID = 17204 FCB::Open failed: Cou...

Read More

CPU usage per database

This script shows all CPU usage of all sessions per database at a certain moment. DECLARE @total INT SELECT @total=sum(cpu) FROM sys.sysproc...

Read More

SQL Memory Performance Issues

If you're wondering if your SQL Server is lacking Memory, you can get your answer easily checking these Performance Counters Threshold...

Read More

Performance DashBoard - User Permissions

When running SQL Performance Dashboard with a simple user without SysAdmin permissions I got the following error: the user does not have pe...

Read More

SQL Server: Shrink Error Log

Each and every time that your SQL server is restated your SQL error log is recreated. The current or last Errorlog is not deleted or overwri...

Read More

SQL 2008 Cluster: The current SKU is invalid

I tried to add a second node to a SQL 2008 Cluster but it fails with this error: The current SKU is invalid Many blogs suggest to la...

Read More

SQL Internals Viewer

SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and st...

Read More

SSIS on a named instance

I ran into a fairly unique problem recently with SSIS in a clustered environment. TITLE: Microsoft SQL Server Management Studio Failed to r...

Read More

xp_cmdshell sql 2008

In SQL 2008 Surface Area Configuration (SAC) is no more available... The functionality of Surface Area Configuration for Services and Conn...

Read More

SQL Express 2008 Limits

The main limits are: CPUs : Only 1 CPU. If a system has more than 1 SQL Express 2008 will still run but limit itself to 1 CPU. RAM : 1 GB. M...

Read More

MSSQL Blocks Tool

This utility has been developed for collecting information on blocking/blocked processes (sessions) from multiple SQL Server 2000/2005 inst...

Read More

SQL Server Browser not working properly

A SQL Server 2005 cluster stopped answering on a named instance, I restarted many SQL Server Browser but it didn't solve... So I started...

Read More

Clustered SQL Server fail to start

I got the following error: The SQL Server (INST1) service terminated with service-specific error 10048 (0x2740). and also Serv...

Read More

Changing SQL Server Version without reinstallation

To change the edition without reinstalling. Just run the setup.exe file from command prompt with the SKUUPGRADE parameter: start /wait setup...

Read More

DBCC InputBuffer and error code 800A0E78

I got the following error while executing DBCC InputBuffer from a vbscript Error: Operation is not allowed when the...

Read More

MUST_CHANGE=Off

I forgot to remove password expiration flag and I got the following error when I was removing it: Msg 15128, Level 16, State 1, Line 1 The C...

Read More

Change Collation of the Model DB (SQL 2005)

I need to change the collation of tempdb, since it's created as new every time SQL Server restart copying the configuration of model DB,...

Read More

Table List: Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

When browsing the table list within SQL Server Management Studio , I received this error: Failed to retrieve data for this request. (Micros...

Read More

SQL 2005 - Sysprocesses Permission

SQL 2000 default permissions allowed user (without System Administrator Rights) to obtain the list of processes querying sysprocess . SQL 2...

Read More