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

20h
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?
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
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
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.
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?
Jan
14
comment Defragmentation of SQL Server 2008 indexes
Explain how you know that it is not "changing fragmentation". Be specific.
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.
Nov
4
comment Trace Flag 1222 Not Working?
Sure, possible, but all of their servers are already setup this way, I don't want to have to change them all, if I can get just this one to work correctly. As for not using both, also possible, but right now, the 1204 is the only way I knew that a deadlock occurred on C and the 1222 did not report it.
Oct
6
comment How to add a default null row if no results from the dynamic pivot query
Even if there are no rows, a result set with defined columns is still returned to your application. Your application should be displaying the column headers even if there are no rows.
Oct
6
comment Defining a column as nullable in a view (but not in the referenced table)
+1: It's worth noting that there are some restrictions with this approach: 1) The changed columns are not writeable in the view, so if the OP's application tries to write to them, it would fail. And 2) the application must not try to distinguish between tables and views. Most apps do not, but annoyingly, some product applications do.
Sep
18
comment Can't see some stored procedures in sys.procedures
Not sure why you posted 100+ lines of unformatted code for us to read, when it's only one four line query that's relevant.
Sep
18
comment How to monitor flat file for changes then run a SQL import job
I assume you mean from within the executing job, for which I am not sure, it's complicated. First thing is to set the Job as being owned by SA. Second thing is to test whether it works in a local folder. If it works locally, but not in the share, then it probably needs the Share/Folder/File settings changed.
Sep
18
comment How to monitor flat file for changes then run a SQL import job
How are you going to import the file? What facility are you using for the import?
Sep
16
comment RESTORE failing with OS error 32, file being used by another process
@SeanGallardy Well, it appears that you are correct and I was wrong on multiple counts. First, yes, it does need to list the logical names from the DB in the BAK file. And secondly, yes, I should have checked it more closely, because it failed when I tried that, because the original logical name had been misspelled (NBCC vs NBBC) and though I stared at it, didnt catch the spelling difference. If you can post this as an answer, I will accept it.