Reputation
2,036
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
7 27
Newest
 Custodian
Impact
~90k people reached

1d
comment Remote access to SQL Server 2008 R2 on Windows Server 2012 R2?
Also, have you tried restarting the instance and/or server?
1d
comment Remote access to SQL Server 2008 R2 on Windows Server 2012 R2?
In "ip\instanceName" is "ip" the server name or it's IP address?
1d
comment What does the FullAccess. infront of table mean in SQL Server query?
ReceivedClaimFact could also be a View or Synonym in the FullAccess schema.
Aug
27
comment SQL SERVER 2014 windows administrator locked and sa password lost
1) does the windows server administrator have sys admins on the SQL server? 2) is there anything else on the server? 3) can your domain admin get in or get admins on the server?
Aug
27
awarded  Custodian
Aug
27
reviewed Approve SQL SERVER 2014 windows administrator locked and sa password lost
Aug
4
awarded  Caucus
Aug
4
awarded  Constituent
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?