Zoinky's user avatar
Zoinky's user avatar
Zoinky's user avatar
Zoinky
  • Member for 9 years, 1 month
  • Last seen more than a month ago
7 votes
3 answers
223 views

Totals(sums/counts) across multiple child tables query optimization

3 votes
2 answers
142 views

Improving performance in a query with median

2 votes
1 answer
3k views

Query extremely slow when joining 2 views

2 votes
1 answer
16k views

How to fix errors reported by DBCC CHECKDB

2 votes
1 answer
954 views

Custom sort before ROW_NUMBER() for paging

1 vote
3 answers
842 views

Lost data, how to recover (sql server)

1 vote
2 answers
1k views

Create view with group by and extra fields

1 vote
1 answer
1k views

SQL Server Table Index To big

1 vote
2 answers
232 views

Improving performance of a view

1 vote
3 answers
605 views

Query very slow when using spatial with radius

1 vote
1 answer
54 views

table size seems high for the amount of records in db

1 vote
2 answers
137 views

How do I add Median to this query?

1 vote
1 answer
34 views

copy data between 2 databases with same tables, but different identities

0 votes
1 answer
88 views

Correct way to get a players position

0 votes
2 answers
154 views

SELECTING TOP X based on last 30 days of activity

0 votes
2 answers
142 views

High SQL Server Usage

0 votes
1 answer
517 views

Efficient where clause on field that has json

0 votes
2 answers
180 views

Query for when comparing to multiple child records

0 votes
1 answer
77 views

Improve performance of query on view

0 votes
0 answers
1k views

TSQL Materiaized/Indexed View Cluster index with subquery

0 votes
1 answer
34 views

Get count of near points based on 2 unrelated tables

0 votes
2 answers
1k views

Improving Speed of Cross Apply

0 votes
3 answers
63 views

Attach 110(2012) from SQL Server 2014 Instance to a (110) SQL Server 2012 INSTANCE

0 votes
1 answer
115 views

Correct way to restore dbs to new server

0 votes
1 answer
181 views

Creating indexes vs Rebuilding indexes (larger db/log file)

0 votes
1 answer
75 views

Can this query be improved? view for few count totals on a table