314 reputation
215
bio website freetibet.org
location Varna, Bulgaria
age 25
visits member for 2 years, 11 months
seen Dec 17 at 10:13

Free Tibet From China Domination

http://freetibet.org/about/10-facts-about-tibet

enter image description here


Dec
11
comment Find out CPU usage by reporting server
Thanks for your answer. I am already using the sp_whoisactive procedure, the issue is a hundres of different queries are cacthed every seconds. I am sure there are a lot of problems with many of them, but my goal here is to detect what is the cost of all queries that are running on the reporting server only - if for example it is 2% of all, I can ignore them and focus on other ones.
Dec
11
asked Find out CPU usage by reporting server
Nov
26
awarded  Popular Question
Nov
25
accepted Restore back up strategy for history tables
Nov
25
asked Restore back up strategy for history tables
Nov
20
accepted How to get CPU usage by database for particular instance?
Nov
19
revised How to get CPU usage by database for particular instance?
added 32 characters in body
Nov
19
asked How to get CPU usage by database for particular instance?
Nov
14
awarded  Tumbleweed
Nov
13
accepted Is there a way to minimally log insert under Always on?
Nov
11
comment Is there a way to minimally log insert under Always on?
Could anyone tell if the numbers of records inserted matters, or the size of the row? I have 37 millions rows to insert, but I can group them in 147 772 rows if I change the table structure (for example XML and ID). The data will be the same as size (maybe bigger) but the rows will be less.
Nov
11
comment Is there a way to minimally log insert under Always on?
Thanks but Minimally logged operations are available only if your database is in bulk-logged or simple recovery mode. (technet.microsoft.com/en-us/library/dd425070(v=sql.100).aspx) and the database in full recovery mode. I am going to check the batches insert examples either.
Nov
11
asked Is there a way to minimally log insert under Always on?
Nov
10
asked A transaction log grows unexpectedly
Nov
7
revised How to fix deadlock caused by “X” locks on same resource?
added 214 characters in body
Nov
7
asked How to fix deadlock caused by “X” locks on same resource?
Nov
5
awarded  Popular Question
Oct
23
asked List with all visible meta data in AFTER UPDATE trigger
Oct
17
comment Search NVARCHAR(MAX) string in other string
Thanks, good to know this.
Oct
17
comment Search NVARCHAR(MAX) string in other string
Sounds like a good time for me to learn something new (PowerShell as you said or C# to write CLR procedure) - I hate when I don't have the knowledge to do something.