Reputation
Next tag badge:
186/100 score
18/20 answers
Badges
10 134 227
Newest
 Enlightened
Impact
~893k people reached

1d
revised Can SSMS Object Explorer Details configurations be exported?
edited tags
1d
revised Easy way to have non-tech users modify database?
Incorporated comments; edited tags
1d
revised Query for a single unique record takes about 1.5 seconds
Formatting; added reference
1d
revised Why can a differential backup not be copy-only?
edited tags
1d
reviewed Close How external/internal fragmentation effect to query performance
1d
reviewed Reviewed Many to many between lots of tables?
1d
reviewed Reviewed How external/internal fragmentation effect to query performance
1d
reviewed Reviewed SQL Row concatenation with XML PATH and STUFF giving aggregate sql error
1d
comment How can I speed up a stored procedure?
There is a meta question concerning the status of this question. Comments have been moved to chat.
1d
revised Group daily schedule into [Start date; End date] intervals with the list of week days
deleted 17 characters in body
1d
revised In SSMS, is “Navigate to” (Ctrl+,) of any use?
edited tags
1d
comment Inconsistent Execution Plan for Stored Procedure
It's hard to be certain, but as mentioned in the answer, I suspect it was due to a recompilation (meaning the optimizer could see the table variable cardinality).
1d
awarded  Enlightened
1d
comment How to configure table with BLOBS (type image)?
You'll need to provide more detail to attract answers. How many rows in the table? How large are the values in the image column on average? How are they accessed? How often? Why are they stored in the database at all? Will you be exporting the data then reloading? Changing in place? These are the sorts of things your question should address. More detail is better when asking how best to configure or architect something.
1d
reviewed Reviewed How to fix “The OLE DB provider ”MSOLAP“ has not been registered”?
1d
revised How to fix “The OLE DB provider ”MSOLAP“ has not been registered”?
Formatting
2d
reviewed Close Get results from a query without calculate it
2d
reviewed Leave Open Completion of SQL Job triggers start of job on a different SQL Server
2d
revised When executing a command via xp_cmdshell what user issues the command to the system?
added 422 characters in body
2d
revised How can I speed up a stored procedure?
edited tags