Oct
16
comment PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on
@solublefish that could be your log file growing (log files don't get IFI and have to zero out) or perhaps your data files are set to grow at very small increments and its happening frequently.
Sep
12
awarded  Enlightened
Sep
12
awarded  Nice Answer
Aug
4
awarded  Popular Question
Jul
31
awarded  Popular Question
Jun
26
comment Availability Group Listener
@EdgarAllanBayron - The cluster IP is an internal IP used by the WSFC itself. The listener IP is a different IP that allows connectivity to SQL Server. They are 2 separate IPs.
Jun
19
awarded  Yearling
May
10
awarded  Popular Question
May
9
awarded  Notable Question
Jan
2
reviewed Close Proper Guidelines for new Database setup in SQL Server
2018
Dec
22
awarded  Nice Answer
Nov
20
awarded  Enlightened
Nov
20
awarded  Nice Answer
Nov
13
comment Identity column changing on its own?
I've seen this happen on older versions of SQL where a ALTER TABLE dbo.SomeTable ALTER COLUMN [ID] bigint not null will actually blow away the identity property of the column. Any chance this is 2008R2? Anything in the schema changes history report regarding that table (assuming the def trace hasn't rolled)?
Sep
18
awarded  Notable Question
Jul
23
reviewed Close Can't empty all my database in SQL Server
Jul
5
awarded  Custodian
Jun
28
revised UPDATE trigger causes deadlock
deleted 1 character in body
Jun
26
comment Why have SQL Server services disappeared from services.msc?
Did you try looking for 'MSSQLSERVER'? I've seen it do that before in services.msc.
Jun
19
awarded  Yearling