Viewing 15 posts - 2,851 through 2,865 (of 6,041 total)
When young children are deep into some game or puzzle, they somehow make time slow down, stretching a single rainy afternoon into an eternity. As adults we somehow lose that...
February 19, 2016 at 12:45 pm
Practically everyone who has been in the industry for more than a handful of years has found themselves in this position at some point. However, it's important not to get...
February 19, 2016 at 7:19 am
Should Production Databases Be in a VCS?
Yes, database administrators should periodically script out the schema for each database and keep it versioned separately under VCS for point in time comparisons,...
February 18, 2016 at 10:48 am
Alan.B (2/17/2016)
Eric M Russell (2/17/2016)
Local user group meetings offer a similar experience. Also, you can find tons of recorded presentations on sites like YouTube and SQLBits.
+1
There's so much good...
February 18, 2016 at 7:39 am
Gary Varga (2/18/2016)
Eric M Russell (2/17/2016)
Gary Varga (2/16/2016)
Eric M Russell (2/16/2016)
February 18, 2016 at 7:17 am
The DMV sys.dm_exec_query_stats returns returns an assortment of aggregated measurements for each cached execution plan. The column sql_handle is a unique hash key.
https://msdn.microsoft.com/en-us/library/ms189741(v=sql.110).aspx
It can be joined with sys.dm_exec_sql_text on sql_handle...
February 17, 2016 at 3:39 pm
For those who are easily bored and need extra motivation to follow through, a sport like surfing or back country hiking is good exercise; because once you're in, you're deeply...
February 17, 2016 at 2:43 pm
Yet Another DBA (2/17/2016)
Eric M Russell (2/16/2016)
Dave Convery (2/16/2016)
@Knut BoehnertTo be fair, if the Terminator is doing it's job, you won't know it's here...
It seems we mostly think of AI...
February 17, 2016 at 10:38 am
Gary Varga (2/16/2016)
Eric M Russell (2/16/2016)
...attempting to use the developer's code repository as a basis for a schema comparison to production is logistically difficult, if not impossible...
It isn't. It has...
February 17, 2016 at 10:29 am
Local user group meetings offer a similar experience. Also, you can find tons of recorded presentations on sites like YouTube and SQLBits.
February 17, 2016 at 10:22 am
If I were to add a #12, it would be this:
It is entirely possible to optimize the top 10 worst performing queries and still not address the specific performance...
February 17, 2016 at 7:16 am
Versioning database scripts is good. However, attempting to use the developer's code repository as a basis for a schema comparison to production is logistically difficult, if not impossible when each...
February 16, 2016 at 12:12 pm
Dave Convery (2/16/2016)
@Knut BoehnertTo be fair, if the Terminator is doing it's job, you won't know it's here...
It seems we mostly think of AI in terms of duplicating or exceeding...
February 16, 2016 at 10:17 am
Gary Varga (2/15/2016)
Eric M Russell (2/10/2016)
Matt Miller (#4) (2/9/2016)
Eric M Russell (2/9/2016)
...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few...
February 15, 2016 at 9:03 am
Viewing 15 posts - 2,851 through 2,865 (of 6,041 total)