Reputation
Next tag badge:
371/400 score
146/80 answers
Badges
3 27 75
Newest
 Caucus
Impact
~1.3m people reached

14h
answered sql server max memory includes SSIS?
17h
comment Potential issues migrating from SQL Server 2014 to 2012 by scripting tables and data?
@Conor thats a very edge case. Once you decide to move on a higher version, then change of mind means poor planning. I can understand your situation and still I believe its an edge case. There are lot of things that can go wrong when you choose a fully functional system to downgrade. HTH.
19h
awarded  Caucus
21h
answered Potential issues migrating from SQL Server 2014 to 2012 by scripting tables and data?
1d
revised SQL Server Max memory limit
added 173 characters in body
Jul
24
comment Maximum character length for a column if I concatenate all the columns together in SQL Server for SSIS packets
You have to choose appropriate datatype e.g. NVARCHAR(MAX)
Jul
24
comment Simple Unpivot - erroneous Column Conflict
It has to be same length .. Did you even read the question ? SELECT [Type] FROM (SELECT cast('Receive' as varchar(8)) AS [Rec], 'Transfer' AS [Trx]) [data] UNPIVOT ( [Orders] FOR [Type] IN ([Rec], [Trx]) ) AS [unpvt]; works ! I marked this a dupe because your resolution is exactly the same - datatype length should be same - not more or less.
Jul
24
comment What do the HT* wait types mean? (HTREPARTITION, HTDELETE, …)
HTREPARTITION => is the HASH_TABLE_REPARTITION. Do you have columnstore index defined on the table ?
Jul
24
answered Quality of Microsft's SQL Server Training/Certification
Jul
24
revised Having trouble with insert query on linked server
added 26 characters in body
Jul
24
revised SQL Server : If a query is cancelled, where to get data on it?
added 22 characters in body; edited tags
Jul
23
answered Need to run query if value in tb1 col1 is 1 and value in tb2 col1 is 1 than run the Insert into query otherwise don't run it
Jul
23
revised SQL server tools to identify query optimisations and missing indexes
added 149 characters in body
Jul
23
awarded  Announcer
Jul
23
answered SQL server tools to identify query optimisations and missing indexes
Jul
23
awarded  Enlightened
Jul
23
awarded  Nice Answer
Jul
23
comment microsoft sql server schema
I need to add tables to in order to track timestamps what timestamps you want to trak ? Table creation? Why don't you create utility database and then query what you want to track and dump the results in utility database. This way you don't mess up the vendor database.
Jul
23
comment Index Seek vs Index Scan
You should merge your profiles - dba.stackexchange.com/users/71236/kumod-singh & dba.stackexchange.com/users/71235/kumod-singh
Jul
23
comment SQL server database performance issue
one database response is 6 times slower Did you check whats running on the server ? Is blocking happening ? Run sp_whoisactive and log that to a table.