Reputation
33,553
Next tag badge:
508/400 score
72/80 answers
Badges
8 87 147
Newest
 sql
Impact
~1.1m people reached

Nov
27
reviewed Approve Update field with new string made from characters in existing value
Nov
27
comment Update field with new string made from characters in existing value
Please state RDBMS. String manipulation functions are not well standardised.
Nov
27
revised Update field with new string made from characters in existing value
added 14 characters in body
Nov
27
comment fundamental difference between Primary/Clustered and Secondary/Non-Clustered index
Primary index and secondary index aren't common terms in SQL Server AFAIK. Primary Key, clustered index and non clustered index all are though. Do you have a particular RDBMS in mind? Where did you come across these terms?
Nov
27
comment SQL Server Concise List Of Trace Flags
Came across another list here though I haven't cross referenced it against any of your other lists
Nov
27
comment DBCC TRACEON (652) does not disable read ahead reads
Are you getting a nested loops join? There is another trace flag (8744) to disable readahead for that.
Nov
26
comment Will one nvarchar column affect query performance?
What is the query and the execution plan for one of these 10-20 second queries?
Nov
26
comment Does the Query cost in Sql Server account for buffering?
The costing model assumes a cold cache.
Nov
25
reviewed Approve Please help configure my Mysql for 12GB 4cores server
Nov
24
reviewed Approve Two slaves using the same server-id
Nov
24
reviewed Approve Looking for a database that supports fulltext but does not lock table on insert or update
Nov
23
awarded  Proofreader
Nov
23
reviewed Approve MySQL performance tuning
Nov
23
reviewed Approve Achieve log transfer to standby (Data Guard)
Nov
22
comment using IDENTITY column with increment -1
Ever decreasing would be all right if the index was also defined as DESC. Otherwise you could end up with fragmentation
Nov
22
reviewed Approve Named pipes connection closed when subjected to load
Nov
22
comment Executing SPs in parallel (maybe with a cursor)
Running it in parallel is possible via service broker or SQL Server agent but will be more cumbersome and probably won't bring you any benefit.
Nov
22
comment using IDENTITY column with increment -1
According to this answer it may cause some problems depending on usage
Nov
22
reviewed Approve How can I organize my tables?
Nov
21
comment One Complex Stored Procedure Causes Estimated Cost Exception
Depending upon what the stored procedure does you might be able to alter it to have lower estimated cost by making things more opaque to the optimiser but seems like you should try and make it more efficient or discuss it with the system administrator.