1,739 reputation
1621
bio website 127.0.0.1
location Frankfurt Am Main, Germany
age 26
visits member for 2 years, 6 months
seen 9 hours ago

-


Aug
7
comment Why aggregate operator used after unique index scan
Looks like an optimizer bug. I have seen other quirks with filtered indexes. The optimizer sometimes cannot derive trivial information from a filtered index.
Aug
6
comment SQL Server 2008 R2, error creating file for FileStream
For Windows Authentication SQL Server seems to impersonate the client sometimes. Try using a SQL login.
Aug
4
comment SQL Server : ALTER TABLE tablename SWITCH PARTITION 2 to tempempty
Locking issue. sp_who2. Who is blocking your switch?
Jul
28
comment Joins between linked servers are dangerous, so can we just load the data into a local table before doing the join?
What does such a problematic query plan look like? Shouldn't SQL Server pull both sources of the join automatically? I don't see what a temp table would help.
Jul
28
comment Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
@VDohnal whatever queries you run - apparently they touch at least 6GB of data. Indexing can help here. Yes, use Profiler to investigate. Look at the columns for logical reads to get a feel for what queries access many pages (and force them into buffer pool).
Jul
28
comment Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
@PhillipH it only does if some partitions (actually, their pages) are not touched. Without changing queries the same set of data will be touched (in most cases).
Jul
28
comment Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
It probably allocates that much memory because those pages are frequently accessed. Optimize your queries so that they touch less data.
Jul
27
comment Huge cross product view query speed
Reduce the number of queries. Is it really necessary to execute one query per row and column?
Jul
27
answered SQL Server 2012 Browser Service doesn't appear
Jul
27
comment SQL Server 2012 Browser Service doesn't appear
"But I am having SqlException Error" that is not a useful error description. What did you conclude of that exception?
Jul
27
comment SQL Server 2012 Browser Service doesn't appear
@KeremZaman how did you check it?
Jul
27
comment Why would SELECT * be magnitudes faster than SELECT foo?
The ORDER BY NUMBER syntax is quite error prone.
Jul
24
answered Should I shrink my database?
Jul
24
comment SQL 2008 Server - performance loss possibly connected with a very large table
Sounds like the hot working set of this data is starting to exceed the buffer pool size. That manifests itself in latency spikes that are becoming more and more frequent. Performance falls off a cliff.
Jul
24
comment Are we a good fit for SQL Server Enterprise and table partitioning?
Especially the last point is a good idea before expending 50k$.
Jul
24
comment Are we a good fit for SQL Server Enterprise and table partitioning?
If all data is in memory more disks will not change anything.
Jul
24
comment Are we a good fit for SQL Server Enterprise and table partitioning?
It is not clear that you have exhausted all your indexing options. It sounds like you want to partition by year because you are querying by year. So just index by year. Wouldn't that work?
Jul
24
comment Are we a good fit for SQL Server Enterprise and table partitioning?
If indexing cannot make your queries faster, partitioning rarely can.
Jul
24
comment Restore Verify Only w/ Transaction Log Backups
Yes, I'd definitely take a differential backup because right now your potential for data loss is expanding with every second passing until you create a full or diff backup. You are probably out of SLA.
Jul
23
comment How do I include nulls during comparisons in SQL Server?
@DMason I respect yours.