Reputation
1,002
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 9
Newest
 Scholar
Impact
~40k people reached

Apr
19
comment Split URL string into columns
Don't do the string splitting within Sql Server. Look up parametrized queries and do string manipulation in application code.
Mar
16
awarded  Scholar
Mar
16
comment Incremental statistics: find out which partitions have been resampled
It looks like incremental stats are not quite as nice as the documentation hints to. This and querying an undocumented DMV strongly suggest that maybe next version will have more comprehensive feature set.
Mar
16
accepted Incremental statistics: find out which partitions have been resampled
Mar
14
awarded  Student
Mar
14
asked Incremental statistics: find out which partitions have been resampled
Feb
29
comment Cloning a database to another collation
What collations would the source and destination be? You are likely to need explicit data conversion rules.
Feb
29
revised replication error
Tagged as MySql
Feb
29
suggested approved edit on replication error
Feb
29
answered how to access a table containing . in its name
Feb
24
revised Moving to Production database for first time
Typo fixing.
Feb
24
answered Moving to Production database for first time
Jan
17
comment Why SQL Server Express 2012 take automatically backup in “Virtual Device” without virtual device configuration?
Is there a Windows OS level backup? Those usually use Sql Server's VSS provider when backing up and can be seen as backup to virtual device in Sql Server's logs. So ask the server / backup admin team if such a job exists and check if the schedules match your observations.
Jan
13
comment How to copy data from one database to another database efficiently?
How much data (rows and gigabytes) are you dealing with? Is the source static or changing? Can you afford any downtime?
Jan
8
comment ROUND VS CONVERT FUNCTION
@VladimirBaranov Fair enough, measurement must be done with proper care. Anyway, the difference observed is so small that unless there is really an issue, I wouldn't bother with further testing.
Jan
8
answered ROUND VS CONVERT FUNCTION
Dec
31
answered Can SQL Server 2012 FCI have multiple names?
Nov
17
awarded  Yearling
Nov
10
comment DB backups not secheduled
The Windows server backup will back up all files on your system, unless you configure excludes. It recognizes Sql Server's files and will use VSS snapshot to get a consistent state for backup. Solution: ditch the maintenance plan, use Ola's scripts and config the Win server backup to exclude the DB data and log dirs.
Nov
10
comment DB backups not secheduled
The freezing comes from VSS snapshot that server backup is doing.