This account is temporarily suspended to cool down. The suspension period ends on Feb 10 '15 at 16:48.
1 reputation
1310
bio website
location
age
visits member for 3 years, 6 months
seen Dec 19 at 15:17

Nov
16
comment Trigger vs Stored Procedure
What is the question given that the behavior is different. How do you FORCE a SP to be used? a Trigger and a SP have totally different targets.
Oct
22
comment SQL Server Performance
Depends. Is your database large enough? If it already fits, more ram obviously will not really help.
Oct
8
comment Clustered columnstore indexes and foreign keys
Beware -it can handle joins. A FK relationship is totally not needed for a join. It is there to handle referential integrity - which is nice to have but in a data warehouse CAN be omitted. At a risk, yes, but also with a performance gain.
Jul
7
awarded  Revival
Jun
17
comment How to uninstall SQL server 2012 not showing in control panel's “Programs and features”
Reformat computer. Open job portal. Find job outside IT. Ok, seriously - time for a clean reinstall. You seem to have managed to do a lot of stuff no professional would like doing and now come and ask us to magically fix it. No way. I wold be afraid of side effects even if I got it going.
Jun
13
comment Virtual SQL Server not consuming enough CPU
Especially latency. Databases LOVE IO - actually they are totally IO Dependant. I manage some virtual sql servers and - the relevant IO is NOT virtualized (i.e. the database servers have dedicated discs physically mapped) and they overload them alone ;)
Jun
13
comment Virtual SQL Server not consuming enough CPU
"IO times look good". Yeah. Please have that qualified. As in: latency should be below 5ms with small spikes upward. CHeck your stats in sql server (it is not like there is no activity view) to check that yourself. and get some RAM - 6 cores I would not run with less than 12gb. Oh, and voting to close - there is a special website dealing with database administration. Besides the qualification required here (professional, no beginners) and you do not really make that impression ("io looks good I am told").
May
23
comment Lost my SQL Server 2005 host, SQL Server 2005 database import into SQL Server 2012?
Wll, you do have a backup, right? If not - what do you care about the data now?
May
6
comment Designing a database with Ints
What database? Optimizing WILL optimize disc and space use. For 100 rows - forget it. For 100 billion rows - how you plan to survive that otherwise? Generally, though, being lazy never pays long term, so why not just do it.
Apr
3
comment How do I tell the actual IOPS used by Oracle?
Let's move the question to the dba's.
Apr
1
comment How to increase application performance with Centralised SQL Server
I agree with Rowland. And get a book. your questions has tons of data that is totally irrelevant and npo relevatn sthigns -llike you do not now anything about SQL you did not pull via copy / paste. A good intro book would help (SQL for dummies) with the obvious stuff. Like indices.
Feb
28
comment SQL Server- Table partitions on SSD
Well, says a lot about your systems. Check stackoverflow.com/questions/2701143/… for the reality.
Feb
28
comment SQL Server- Table partitions on SSD
Actually it is not - at least not signiciantly. It is faster because it forces the clustered index to be sensible - but if you do the same on a non-clustered table you have pretty much the same performance. BUt deletion is different. Care to read for example stackoverflow.com/questions/2701143/…
Feb
28
comment SQL Server- Table partitions on SSD
MANAGING LARGE DATA is ot querying. It is deleting. Try deleting 100 million rows of a 10 billin table. Compare that to swapping out the partition and using truncate on it. That is management. Not making a select faster which is executed based on the partition index statistics anyway.
Feb
28
comment SQL Server- Table partitions on SSD
-1. Because that is what the INDEX in the partition does. Funny enough it also does do without the partition, so it won't be MUCH faster. PArtitioning is about fast deletes of a complete partition.
Feb
28
answered SQL Server- Table partitions on SSD
Feb
16
awarded  Fanatic
Feb
10
answered Difference between oracle database desktop and server class
Feb
10
answered Query hangs forever at first but works after one day
Feb
10
comment Best practices for configuring the Drive/Filegroup setup for Microsoft SQL 2008
Yes. But if someone says "SCSI drives" then I assume he means that. YOu know. SCSI like SCSI bus with terminator. Do you know what SCSI stands for?