395 reputation
211
bio website sqlblog.lv
location Latvija
age 31
visits member for 2 years, 9 months
seen Oct 14 at 10:05

MCITP: Database Developer 2008


Sep
12
awarded  Notable Question
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.