meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 8 months |
| seen | Jun 6 at 16:35 | |
| stats | profile views | 6 |
|
Feb 13 |
comment |
SELECTing multiple columns through a subquery Try the hints in this post: meta.stackoverflow.com/questions/156729/… |
|
Feb 13 |
comment |
SELECTing multiple columns through a subquery Do you have any sample data available? |
|
Feb 13 |
answered | SELECTing multiple columns through a subquery |
|
Feb 5 |
comment |
Efficiently Filter Large Set With Disjunctions Would it be possible to place your subquery into a temp table or table variable and build that way? With my larger tables, I sometimes get stung by subqueries. Covering indexes only take you so far. |
|
Jan 14 |
accepted | Restore only one datafile in SQL Server 2008 from partitioned database |
|
Jan 11 |
asked | Restore only one datafile in SQL Server 2008 from partitioned database |
|
Sep 29 |
awarded | Yearling |
|
Feb 29 |
comment |
How do I determine why my stored procedure is getting deadlocked? Yay! Glad it worked! |
|
Feb 29 |
answered | How do I determine why my stored procedure is getting deadlocked? |
|
Feb 28 |
comment |
How do I determine why my stored procedure is getting deadlocked? Have you checked to see if any stats on the tables in question are out of date? When I've seen issues like this, it's usually a highly-fragmented index (or missing index) or stats that are woefully out of date; as a result, the server spends way too much time sorting through data and not nearly enough actually running the query. |
|
Feb 10 |
answered | SQL Server 2008r2 replication from multiple sources |
|
Feb 9 |
comment |
SQL Server 2008r2 replication from multiple sources Does all the data have to go into the master database from the get-go? Or can it make a first stop into a replicated copy on the master server and then get transferred in via another method? |
|
Dec 7 |
comment |
how to Export a document contain tables name, columns names and column description from SQL Server 2008? Previously: stackoverflow.com/questions/887370/… |
|
Nov 15 |
answered | How to avoid select combinations created with multiple parameters (with value or without value) passed in to stored procedures for a select in sql? |
|
Oct 21 |
answered | SQL Server 2000 to SQL Server 2008 linked server issue |
|
Oct 17 |
awarded | Scholar |
|
Oct 17 |
accepted | SQL 2008 R2 Datafile Too Large To Empty or Remove |
|
Oct 16 |
answered | SQL 2008 R2 Datafile Too Large To Empty or Remove |
|
Oct 16 |
comment |
SQL 2008 R2 Datafile Too Large To Empty or Remove This would work in theory, if there were enough available space to add datafiles and new filegroups. Unfortunately in this case, no dice, because this huge file is eating up all the drive space. Shrinking it piecemeal and occasionally rebuilding indexes fixed the issue, though. |
|
Oct 14 |
awarded | Editor |
