Reputation
753
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
3 7
Newest
 Yearling
Impact
~19k people reached

Apr
19
comment What is stored in a transaction log file?
Have you read the documentation?
Apr
17
comment Why are transactions long running?
Post the execution plan and show the procedure code too. Without those, it's just idle guessing.
Apr
14
answered Script to merge-replicate two MDF database files?
Apr
13
comment SQL Server : execute stored procedure from another stored procedure
Please keep in mind that table variables lack statistics and thus might throw the query optimizer to very wrong a path.
Mar
24
comment How to set IN values on an update (SQL Server)?
It would be quite helpful to include the error message you got.
Jan
20
comment How to insert or update using single query?
Merge has some issues.
Jan
19
answered Query data before a commit transaction
Jan
9
comment Stored Procedure never completes with Exec, but i can run the Query in SSMS
You don't use the schema prefix for the sproc. Is there another a sproc with same name? You do use the same -2 as qtdDias when executing just the query as such?
Dec
9
comment Is it advisable to restart a SQL server box running Windows when disk space is low?
How excactly are you trying to move a database? What kind of disk config you got and where are you going to move the db files?
Nov
24
comment Backup table is larger than original table
How is the backup table created? Is data compression being used?
Nov
17
awarded  Yearling
Nov
11
comment DBCC error reported
Which version of Sql Server? What did you do that triggers the errors?
Oct
29
answered Paging in SQL Server: Is an order by clause required? (currently, rows are being missed)
Oct
6
comment Compress files and directories into zip file and put it into blob field
I still think that using Sql Server to send a zip from the server's HDD to a client is either a) monkey business b) very wrong solution attempt to a valid business problem that's easily resolved with entire different an approach. Why use Sql Server at all?
Oct
3
comment Compress files and directories into zip file and put it into blob field
This sounds like the Xy problem. What are you trying to do anyway?
Sep
24
awarded  Autobiographer
Sep
22
comment Is it possible that records are changed while a read query is still executing?
InnoDB claims full ACID compliance, so no partial insert should be able to mess data consistency. That being said, with right isolation level, a transaction that won't be committed might mess up your data anyway. So, please study carefully the transaction isolation theory and documentation.
Sep
18
answered Is it possible that records are changed while a read query is still executing?
Sep
17
comment How to schedule jobs in Sql server 2008 for less than 10 sec?
Read about the Xy problem and consider about updating the question.
Aug
28
comment How to get Identity Column to jump ahead (by say 1000) on SQL Server 2012
@Gabe For example, merge requires semicolon usage. See also Aaron's blog.