Reputation
4,304
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 21 39
Newest
 Caucus
Impact
~230k people reached

Jul
18
revised SQL Server Slowdown?
deleted 11 characters in body; edited title
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
18
revised How to add new named instance in SQL Server 2012
deleted 5 characters in body; edited title
Jul
18
revised How to make SQL Server 2008 compatible to SQL Server 2000
added 21 characters in body
Jul
18
revised Why would you put Identity Increment other than 1 in SQL?
added 5 characters in body
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
revised Problem trying to force the use of a filtered index
added 20 characters in body
Jul
12
revised SQL Server : auditing AD Users - how can we identity AD User account from AD Groups
deleted 3 characters in body; edited title
Jul
12
revised Possible to upgrate SQL Server 2012 express to 2012 Standard?
deleted 9 characters in body
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
12
revised SQL Server 2012 replication setup on routed network
added 10 characters in body; edited title
Jul
10
revised nvarchar(max) converting to varchar and table optimization
deleted 7 characters in body
Jul
8
revised Excessive CPU use in vendor SQL Server DB
added 25 characters in body
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
Jul
6
revised Optimize a SQL query
added 335 characters in body; edited title
Jul
6
answered Trigger Gives an Error on Multiple Rows SQL SERVER
Jul
6
revised stored procedure not showing a result
added 253 characters in body
Jul
6
revised SQL Server Configuration Manager shows no services
edited body; edited title
Jul
6
revised How to do housekeep the database in sql server 2008 by specific date range?
edited tags