395 reputation
111
bio website sqlblog.lv
location Latvija
age 31
visits member for 2 years, 7 months
seen 2 days ago

MCITP: Database Developer 2008


Oct
30
awarded  Popular Question
Sep
18
awarded  Popular Question
May
21
answered SA permissions issues with many nested objects
May
14
awarded  Caucus
Mar
8
comment Select MaxDate where hh:mm:ss makes the difference
if there is 2 rows with the same timestamp and tag, there still can be duplicates.
Mar
6
answered Select MaxDate where hh:mm:ss makes the difference
Feb
28
comment How to select the first 10 records for each table in the same database using sql
@AaronBertrand if you like so..
Feb
27
answered How to select the first 10 records for each table in the same database using sql
Feb
26
awarded  Nice Question
Feb
26
accepted What exactly does “No Join Predicate” mean in SQL Server?
Feb
21
comment What exactly does “No Join Predicate” mean in SQL Server?
@PaulWhite So there is possible to get situation, when I have one-to-many relationship and I get this warning?
Feb
20
awarded  Autobiographer
Feb
20
asked What exactly does “No Join Predicate” mean in SQL Server?
Jan
23
awarded  Yearling
Nov
1
comment UTC date in DMV dm_broker_queue_monitors
well, last_empty_rowset_time and last_activated_time- both happens on my instance, so i dont care about time on those computers who send "Receive" command (and UTC in this case is not addressing that anyway).. Thanks for proposed solutions.
Nov
1
revised UTC date in DMV dm_broker_queue_monitors
edited tags
Nov
1
accepted How many connections reads queue
Nov
1
asked UTC date in DMV dm_broker_queue_monitors
Oct
31
comment How many connections reads queue
Messages are processed in console app, it calls web services, sometimes it can slow down (it happens while receive transaction is open). Was thinking of the easy way to monitor what is happening.
Oct
30
comment How many connections reads queue
just like internal activated procedures- if there is connection AND transaction that reads data from queue, then 1, else 0.. (and it is possible to see how many external tasks is waiting for message to arrive to queue) @Damien_The_Unbeliever