Index Utilization Trending
An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?
2014-05-05
6,787 reads
Dynamic management views
SQL Server 2014 In-Memory OLTP Dynamic Management Views
Greg Larsen provides a quick primer of the new Dynamic Management Views (DMVs) to help you better understand and manage your In-Memory OLTP tables and your Instances that support In-Memory OLTP tables.
2014-04-16
4,379 reads
Review Your BUCKET_COUNT Statistics with DMV
Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.
2014-03-19
2,032 reads
Find Top 5 executed queries ordered by execution count
I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2015-03-04 (first published: 2013-09-23)
3,828 reads
RE: LINK Servers in Mix Mode giving Error 18452
Were you running the query from the source server (ie the server where linked server is setup) ? If you are running from a client then delegation needs to be setup for the windows authentication to be carried to the linked servers. Just to verify this run the query from the server (ie EM on […]
2004-04-07
RE: CAN SOMEONE EXPLAIN TLOG MECHANICS (GROWTH, SHRINKAGE) ???
OK thanks for all the help. I've got it nailed now.
2004-03-30
RE: sql injection articles
In the example the person is building a call to an SP in dynamic SQL whether it is in TSQL or VB it is still putting strings together thus the problem. If you are using ADO and a command object with parameters then SQL is passed to the SQL engine slightly differently each parameter value is […]
2004-03-29
RE: T-SQL Experts - Can this SP be recoded to work as a UDF
I believe this needs "DECLARE <name> INSENSITIVE CURSOR FOR";otherwise its not in a loop...Insert Into @temp Select Distinct employeeid From directory Where higmanagerempid = @empidMy suggestion was: recalling a UDF with @empid (for each level) until none found. You can still share temp tables and results, so all iterations provide a complete tree […]
2004-03-22
RE: Strange Login Failure
the workstation used for keith does not belong to the DOMAIN where SS is!-- join to the domain and you should be happy HTH
2004-02-25
Blogs
Our Contributions Towards a Stronger Open Source Future
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers