Reputation
2,011
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
6 25
Impact
~85k people reached

Jul
20
awarded  Popular Question
Jul
11
awarded  Notable Question
Jun
19
awarded  Curious
Jun
18
comment Fixing a corrupt Log File in small downtime window
Weird. I just got a badge for 2500+ views of this question, yet it has never received any votes, Up or Down. I'm not complaining mind you, just seems odd...
Jun
18
awarded  Notable Question
Jun
12
comment Create Database and LCK_M_S
How often are you creating new databases on this SQL Server?
Jun
9
comment How to select only few columns from a table in database?
This table is a non-relational ("bad") design because it appears to break Codd's First Law of Normalization (no repeating columns). SQL is a relational style DBMS language that works best facilitating relational data designs. Trying to use this (really bad) approach will constantly turn up problems like the one you are asking about here and ultimately seem incredibly kludgy and difficult to use. In short, you appear to be going about this all wrong.
Jun
9
answered SQL Server Data File/Log File poor performance
Jun
9
comment How to select only few columns from a table in database?
The fact that your columns are identified by the number instead of having unique, meaningful names, is a pretty sure indication that the design is not relational. Almost all of your problems dealing with SQL, your tables and their data is going to come from this fact. For example, your current question.
Jun
9
comment SQL Server Data File/Log File poor performance
Points: 1) RAID 5 is a poorly performing configuration for database files especially for writes, and 2) Partitioning is even worse. Yes, it works and is reliable, but it's definitely a low-performance disk configuration that I would only use myself for development or the most light-weight of apps.
Apr
17
awarded  Yearling
Mar
24
comment SQL server not using the memory allocated
Silly question, how large are the databases?
Mar
24
comment SQL server not using the memory allocated
First, what edition of SQL Server is this? (Enterprise, Standard, Workgroup, etc.). Secondly, tell us how you arrived at the conclusion that SQL Server is not allocating the memory, what tools did you use and what did you observe? Finally, how is your SQL Server being used, and what was going on in your SQL Server while you were making these measurements?
Feb
20
awarded  Popular Question
Jan
14
comment Defragmentation of SQL Server 2008 indexes
Explain how you know that it is not "changing fragmentation". Be specific.
Jan
5
awarded  Popular Question
Dec
12
comment Retrieve XML of large plan from plan cache
IIRC, you may have to create a new query window. You shouldn't have to restart SSMS, though that should also work.
Dec
12
comment Why does SQL authentication sometimes fail and how can I make it work reliably?
If "SQL Login does not work", then you are not doing it correctly. SQL Logins do NOT need to talk to the Domain Controller. Either you are not really doing a SQL Login, or your SQL Server has not been set to allow mixed mode authentication.
Nov
24
comment Performance decline function vs command window
We will need to see both of the query plans.
Nov
5
comment Trace Flag 1222 Not Working?
@kin yes, I am aware that I could use the system_health, or profiler, or extended events, etc., etc... All of these would require additional development, testing and deployment to integrate them into what the customer already has. I know how to do all of this and have done all of these at one time or another. That is not what I need help with. If I can correct the one broken server, that would be preferable to changing everything else.