Reputation
11,772
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
7 28 63
Newest
 Taxonomist
Impact
~423k people reached

8h
comment Index fragementation ? is it unavoidable
Yes. That's why you see many people, Mr. Randal included, recommending you defragment indexes on an as-needed basis.
14h
revised How to order by alphanumeric codes in SQL Server
added 183 characters in body
14h
answered How to order by alphanumeric codes in SQL Server
17h
comment Why did windows “repair” delete my database tables?
Always take a backup of your system prior to running a "repair" of any kind. Bet you already know that now, though.
18h
revised sys.sp_reset_connection. Why theres a lot of them ?
edited title
18h
comment sys.sp_reset_connection. Why theres a lot of them ?
What problem are you wanting to solve?
19h
reviewed Approve Multiple database directories with postgresql
20h
comment Can we create indexes on views in SQL Server?
See this answer: dba.stackexchange.com/a/14903/10832
22h
revised How MySQL Queries and Questions status variables are calculated?
edited tags
22h
revised How to insert UNIQUE IDs values from several tables into events table
edited tags
22h
revised Unable to import database through osm2pgrouting
edited tags
22h
reviewed Close Oracle server 11g stops working with 12541 error until IP address changes
22h
reviewed Reopen Grouping based on the status, then count its product and the total based on its category ID
1d
comment JDBC local MSSQL Server connection string
Remove the port (1433) from the instance name (the instance name is the port).
1d
revised When Should You Shrink Your Database
added 4 characters in body
1d
comment JDBC local MSSQL Server connection string
Where you have localhost:1433 replace that with the instance name.
May
23
comment SQL Server 2008R2 to SQL Server 2012 Install
You've eliminated this? stackoverflow.com/questions/22088932/…
May
22
reviewed No Action Needed Symmetric difference operation in Transact-SQL?
May
22
comment Query to flatten schema
Hence why almost all DBAs hope and pray developers don't want to use an ORM.
May
22
revised Several Foreign Key and Cascade Delete SQL Server
added 43 characters in body