Alocyte's user avatar
Alocyte's user avatar
Alocyte's user avatar
Alocyte
  • Member for 10 years, 4 months
  • Last seen more than a week ago
  • Cape Town
3 votes

I/O is frozen on database databasename

3 votes

How do I format the output from OBJECT_DEFINITION so that it looks the same as sp_helptext?

2 votes
Accepted

SQL Job PowerShell task fails same command succeeds as user

2 votes

Compatibility level when upgrading a SQL Server 2005 database to SQL Server 2012

2 votes

ONLINE vs OFFLINE index rebuilds

2 votes
Accepted

Normalisation to 3NF

2 votes
Accepted

reporting space consumption to files in filegroup - how to reverse-engineer the algorithm spreading data across files

1 vote

How does SSMS grab the name of my server?

1 vote

SQL Server 2012 enlarge database space

1 vote
Accepted

Order to restore system and user databases

1 vote

How to design a database for financial bond prices?

1 vote

Getting duplicate results in many to many query

1 vote

Backup to Azure Storage Container: Shared Access Signature the only way?

1 vote

MS SQL Server - Table with Queue logic - How can I be sure that parallel tasks will not retrieve the same ID?

1 vote
Accepted

SELLECT * FROM Table WHERE name=$variable not working

1 vote

How to speed up ALTER COLUMN when changing column size on big tables, leading to SUSPENDED state / PAGEIOLATCH_EX wait type?

1 vote
Accepted

Is a Clustered Index Scan bad for performance?

0 votes

not return count = 0 if value is null - oracle

0 votes

SQL Server memory issues after upgrade from Express

0 votes

Selecting data from multiple rows into a single row multiple columns

0 votes
Accepted

How should I correctly do modelling with this data?

0 votes

SQL Server Agent Job sometimes doesn't execute as User

0 votes

Is there a way to restore SQL database while skipping some log files?

0 votes

Query is much slower with indexes

0 votes

How to move a SQL database datafile located at VHD to another disk?

0 votes

Massive INSERTs blocking SELECTs

0 votes

SQL server in memory table performace

0 votes
Accepted

SUM of column by GROUP BY which is WHithin a GROUP BY

0 votes

Should I choose subquery or 'group by' for faster performance

0 votes

INSERT and SELECT query