Reputation
853
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 7
Newest
 Yearling
Impact
~25k people reached

Jul
13
answered Powershell - SQL Server - connectionstring in loop for multiple Instances
Jul
6
answered How to do housekeep the database in sql server 2008 by specific date range?
May
19
comment Single query for searching for records without knowing what the search column is for
So you are getting wrong results. Add table structure, sample data, query, expected and actual results to your post. Without those, it's all guessing from simple typo to an error in query logic.
May
19
comment Single query for searching for records without knowing what the search column is for
What, exactly, does "its not working" mean? Wrong results? Error message? Something else, what?
May
11
comment Why temdb and log file size is not reduced by SQL Server
@Zerotoinfinity Sql Server does remove data from tempdb after it's done. The thing is, removing data from any database will not cause the db files to shrink. The space within db is just marked as unused.
May
11
answered Why temdb and log file size is not reduced by SQL Server
Apr
28
comment Using of OPTIMIZE FOR hints in a sql query
@Kaja Please benchmark the queries. A careful examination of execution plans will tell you if incorrect sniffing happens or not.
Apr
28
answered Using of OPTIMIZE FOR hints in a sql query
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?