Reputation
614
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 5 15
Newest
 Yearling
Impact
~51k people reached

May
26
awarded  Yearling
May
19
comment backup to NAS using sqlcmd
We're actually running a job from SQL Server Agent Service Account and operation type is CmdExec
May
19
asked backup to NAS using sqlcmd
May
12
revised OLE DB Driver sql 2008r2 to Oracle failing
improve readability
May
12
suggested approved edit on OLE DB Driver sql 2008r2 to Oracle failing
Apr
15
comment Restoring a backup of a database from SQL Server 2014 into SQL Server 2012
DBAreactions to this question
Apr
8
comment Is SQL injection a neccesary feature?
Your question is too broad, I would say it will just trigger opinion based answers and not accurate answers. Maybe you have an underlying problem that you are trying to solve and you are asking about a possible solution instead about the issue itself? The XY problem
Mar
31
comment Check the data latency between two Always On Availability Group servers in ASYNC mode
Saved my day! Working on adding some more data and make it even more handy for monitoring AlwaysOn AG. Awesome!
Mar
11
answered Please help in understaning DeadLock Graph
Mar
10
comment What is the difference between normal Select query and a Select query inside Common Table Expression(CTE)?
Weird question, IMHO, have you searched a bit about what is a CTE, how it works and how can be used? And I mean on SE site, not even using your prefered search engine for a global search. Look for CTE vs temp tables, CTE vs subquery, CTE recursive, CTE performance, How CTE really works?.
Feb
20
awarded  Excavator
Feb
20
revised SQL Server 2012 AlwaysOn: need to automatically add databases by script- T-sql or PowerShell
code and text formatting for better readability
Feb
12
comment Too big database file 90GB
The database has a growth rate of 90GB daily? Or is just it's current size? If it's current size, then no worries, that's nothing to worry about. But if it is growing at that speed daily, then you have something to deal with. As for other questions, as usual, it depends.
Feb
11
awarded  Tumbleweed
Feb
4
asked Adding lot of new role assignment on different folders
Nov
26
asked databases cross references baselines
Nov
11
comment Getting Time Duration
If you're using SQL Server 2008R2 my advice is to retag the question so it gets answers for that particular version. Maybe some solution could apply just to 2012 or above for example.
Nov
11
revised Getting Time Duration
code formatting improvements
Nov
11
suggested approved edit on Getting Time Duration
Sep
30
comment MySQL backing up MyISAM tables by copying the physical files - and automating the process
Have you checked the related questions recommended to take a look when you created the question? There are couple of them that I think will answer your question, with plenty of details and scripts to test. Copying database files from one location to another seems not the right thing to do.