Reputation
4,682
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 25 40
Newest
 Yearling
Impact
~312k people reached

Dec
23
comment Rebuild index in SQL Server does not reduce fragmentation
Can you elaborate WHY you recommend those settings?? Most definitely #4 seems very much disputed ..... (e.g. the fact that a clustered index exists on an identity column really doesn't make much difference - if such a table is updated frequently, you would still want to have a lower fill factor!)
Nov
19
comment Statistics and Execution plan in SQL Server
It's statistics - not statics .....
Nov
1
comment SQL Server CASE statement dependent on other rows in result set
CASE is SQL Server is an expression - not a statement. It's an expression that can return a single value based on some conditions - it's not a statement that can control program flow etc.
Oct
20
comment How to create a stored procedure to update database after table edit
The error clearly says: the way you're calling this stored procedure from your ASP.NET code is wrong - you're providing too many parameters - you need to show us that code - not your T-SQL stuff ....
Oct
20
comment How to create a stored procedure to update database after table edit
ntext, text, and image data types will be removed in a future version of SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead. See details here
Oct
8
comment SQL Server 2012 running background task that fills memory
You need to change settings at installation time - namely the "max server memory" that you allow SQL Server to use. If you don't specify anything, it'll use up all your memory, if it can.....
Sep
15
comment Need help with SQL Server configuration
@ankitsuhail: there is a Windows Server 2012 R2 - but no SQL Server 2012 R2 - so it's not quite clear which product he was referring to ...
Sep
15
comment Restore from SQL Server 2008 R2 to SQL Server 2014 fails
Your list has incorrect - the increase from 4 to 10 GB came with SQL Server 2008 R2 Express (not 2008 Express) - fixed
Sep
15
comment Need help with SQL Server configuration
There is no SQL Server 2012 R2 version - just 2012 - corrected
Sep
4
comment Upgrade Database from SQL Server 2008 to SQL Server 2008 R2
As the error message clearly states - your local DB version is 10.00.1600 (SQL Server 2008 - no R2)
Aug
31
comment Wide clustered index vs multiple narrow nonclustered indexes?
Since the clustered key columns are present in all nonclustered indices as well, the clustered index should be as narrow as possible ... otherwise you'd be wasting potentially a lot of disk (and memory) space for nothing
Aug
29
comment Event 17058 - initerrlog: Could not open error log file (SQL Server)
What are you trying to run sqlservr.exe ? When you install SQL Server, a Windows service is created that automatically runs at system startup - no need for you to manually "run" sqlservr.exe at all ...
Aug
10
comment SQL Server restore database with active connections
My response here to this other DBA.SE question shows how to do it - this was about dropping a database in use - but the same steps also work for restoring a database that's currently in use
Aug
3
comment Create an AD user from a SQL Server trigger
Don't do this from within the trigger! The trigger should be fast and nimble - it should not do heavy lifting and time-consuming processing - and it should most definitely not be calling up an external resource that might take quite some time to respond! Instead - let your trigger make an entry into a "command" table, and have a separate process (T-SQL job or a little utility in any other language) read and interpret that command table and handle the actual creation of an AD user..
Aug
1
comment Problem with clustered index? Or bad indexes? (SQL Server 2008 R2)
Set Bad Habits to kick - putting NOLOCK everywhere - it is NOT RECOMMENDED to use this everywhere - quite the contrary!
Jul
18
comment How to add new named instance in SQL Server 2012
Adding a new instance means installing again - with a new instance name - no way around this.
Jul
16
comment Restore SQL Server 2008 database onto SQL Server 2014?
What is the compatibility level of that source database? SQL Server 2012 and newer do not support compatibility level 80 (SQL Server 2000) anymore ....
Jul
12
comment Stored procedure return -1
The stored procedure return value typically indicates the number of rows affected by your operation in the stored procedure. If you're not inserting, updating or deleting anything, then there are no rows affected, thus the return value might be -1 - this is not an error!
Jul
12
comment Stored procedure return -1
Side note: you should not use the sp_ prefix for your stored procedures. Microsoft has reserved that prefix for its own use (see Naming Stored Procedures), and you do run the risk of a name clash sometime in the future. It's also bad for your stored procedure performance. It's best to just simply avoid sp_ and use something else as a prefix - or no prefix at all!
Jul
7
comment Create new server in SQL Server instance
Install SQL Server on this machine a third time - pick an instance name that's not already in use