Reputation
24,122
Next tag badge:
138/100 score
16/20 answers
Badges
4 47 95
Impact
~813k people reached

7h
comment How to backup full transaction logs for SQL Server 2008R2
Taking a copy of the production database to your CI environment every night seems excessive. Drop that step, snapshot your CI database at the start of the test, run tests, restore from snapshot. Refresh your CI database from production weekly/monthly.
Apr
19
reviewed Close Fetch data from second table based on first table
Apr
19
reviewed Close Calculate percentage of a column group by 2 columns in pivot table format using oracle 11g sql
Apr
19
revised Calculate percentage of a column group by 2 columns in pivot table format using oracle 11g sql
deleted 42 characters in body
Apr
19
reviewed Close Opinion on Database Design for Task
Apr
19
reviewed Close "Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio
Apr
19
reviewed Leave Open Crashing CLR on SQL Server 2014 (windows 2012R2)
Apr
19
reviewed Close What's a good tool for visualizing SQL Agent jobs?
Apr
8
reviewed Close How can I choose the best autogrowth option for my new database?
Apr
7
comment Unable to start SQL Server Browser service in Sql server 2005
There's nothing you can change for the browser service, you need to identify the instance that's bound to 1434 and change it. Before heading down that route you can prove this is what's stopping the browser service from starting by stopping all SQL Server instances so 1434 is released, then starting the browser service. Note that if the instance is configured to start on 1434 it won't with the Browser service running.
Apr
7
comment Unable to start SQL Server Browser service in Sql server 2005
You have a SQL Server instance using port 1434. That's why the SQL Browser service is unable to claim 1434.
Apr
7
reviewed Leave Open Unable to start SQL Server Browser service in Sql server 2005
Apr
7
comment Unable to start SQL Server Browser service in Sql server 2005
@KASQLDBA In the second command where I put <process id> please put the process id returned by the first command. It was "2012" when you ran it the first time.
Apr
6
revised Unable to start SQL Server Browser service in Sql server 2005
deleted 1 character in body
Apr
6
answered Unable to start SQL Server Browser service in Sql server 2005
Feb
20
reviewed Close How does SQL Server know it was abnormally shutdown last time
Feb
19
revised Transaction and data consistency during a failure
edited body
Feb
18
reviewed Close Geographically dispersed SQL Server for Third Party Application
Feb
16
reviewed Reopen Select a range of values
Feb
14
comment SQL Server differential backup LSN values
"If each differential backup contains the data for the transactions of all the previous differential backups..." - it doesn't. A differential contains the extents modified since the last full backup. Modified extents are tracked by the Differential Change Map.