Reputation
4,339
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 22 39
Newest
 Constituent
Impact
~246k people reached

8h
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
May
9
comment Strange SSIS-Package problem ( ASYNC_NETWORK_IO)
Set Bad Habits to kick - putting NOLOCK everywhere - it is NOT RECOMMENDED to use this everywhere - quite the contrary!
Apr
15
comment Restoring a backup of a database from SQL Server 2014 into SQL Server 2012
@BuahahaXD: NO - the compatibility level does NOT change the internal database structures. This does not help - you just CANNOT do this.
Apr
14
comment How to restore mdf file in sql server 2005?
what error message?!?!? I don't see anything .....
Apr
1
comment Execution Plan : Table Insert Cost 90% vs Clustured Index Insert Cost 86%
For a great many reasons, I would argue any serious table in SQL Server should always have a clustered index - therefore, that discussion is kinda moot..... heaps (tables without CI) have serious drawbacks and performance penalties - too many to even bother - use a CI - always.
Mar
25
comment Differentiate SQL Server Express from SQL Server installed in a server
@RayofCommand: it might violate the Principle of Least Surprise - but it's possible ! :-)
Mar
11
comment Keep Execution Plan in Cache - SQL Server 2012
It's going to automatically stay in memory - if you use it frequently enough, and if there isn't any "memory pressure" (too little memory) on the server. You cannot really force a plan to stay fixed in cache - it will be tossed out if memory is too tight....
Feb
21
comment Different runtimes using parameter vs. constant
WHY is DATE_CREATED not a proper DATE datatype?? Please always use the most appropriate datatype - and for a date - that's DATE but certainly not a VARCHAR type!
Feb
10
comment NVARCHAR column as PRIMARY KEY or as UNIQUE column
Actually, NVARCHAR(20) is 40 bytes in size (max), and since it's variable-length column, it's not really the best choice for a clustered index. ID_CODE being a BIGINT IDENTITY would be the much better choice here!
Jan
30
comment Soccer league ER diagram (implementing a many to many relationship)
have some m:n relationships which I know shouldn't exist - WHY do you think m:n relationships shouldn't exist?!?!?!?! Those are just a fact of life! Nothing wrong with that! Where did you "learn" that???