meta user
network profile
| bio | website | sqlblog.lv |
|---|---|---|
| location | Latvija | |
| age | 29 | |
| visits | member for | 1 year, 4 months |
| seen | 21 mins ago | |
| stats | profile views | 9 |
MCITP: Database Developer 2008
|
50m |
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 |
|
Oct 30 |
asked | How many connections reads queue |
|
Sep 5 |
answered | Identify cause of unusual transaction log growth |
