Reputation
4,114
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 19 38
Impact
~188k people reached

Apr
14
revised SQL Server : execute stored procedure from another stored procedure
deleted 16 characters in body; edited title
Apr
14
comment How to restore mdf file in sql server 2005?
what error message?!?!? I don't see anything .....
Apr
14
revised How to restore mdf file in sql server 2005?
added 10 characters in body
Apr
14
revised Script to merge-replicate two MDF database files?
added 10 characters in body
Apr
11
revised Transform 14 columns into 2 (SQL Server 2008) - Pivot/Cursor not helping
added 99 characters in body; edited title
Apr
11
revised SQL Server 2005 query with multiple conditions, some indexed, some not
added 38 characters in body; edited title
Apr
10
revised Converting VARBINARY HEX to VARCHAR
added 70 characters in body
Apr
10
revised Database in Suspect mode
deleted 36 characters in body; edited title
Apr
9
revised SQL Server Query Question
added 70 characters in body; edited title
Apr
9
revised Setting a default principal server in SQL Server 2008
added 2 characters in body; edited tags; edited title
Apr
9
revised Inplace upgrade from SQL Server 2008 Standard to SQL Server 2014 evaluation
added 21 characters in body; edited title
Apr
9
revised SQL Server 2012 Express installation failed
added 2 characters in body; edited title
Apr
9
revised Should a SQL Server DBA know Windows Server and vice versa? Are these roles soon to become synonymous. Or at least more encapsulated/?
added 7 characters in body; edited title
Apr
6
revised From keyword not found?
edited tags
Apr
6
revised Oracle to SQL Server query conversion. Getting “Argument data type int is invalid for argument 1 of substring function.” error
deleted 15 characters in body; edited title
Apr
4
revised I cannot restore a SQL Server database in a new location
added 15 characters in body
Apr
4
revised “Incorrect Syntax near S” in Stored Procedure
deleted 275 characters in body
Apr
1
revised Rolling back a SQL Server 2008R2 Database stored in SQL Server Express
edited title
Apr
1
comment Procedure or function 'sp_InsertImages' expects parameter '@Img_path', which was not supplied
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!
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.