Viewing 15 posts - 2,851 through 2,865 (of 6,038 total)
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
Gary Varga (2/15/2016)
February 15, 2016 at 6:52 am
SSIS is an ETL tool, so you would use it to copy data to and from Oracle. If what you want is to query data from Oracle, then you'll need...
February 12, 2016 at 3:19 pm
If you have to ask, then the answer is probably yes, at least to some degree.
February 12, 2016 at 2:16 pm
Viewing 15 posts - 2,851 through 2,865 (of 6,038 total)