About 1,839,881 results (3,365 milliseconds)
What 5 things should SQL Server get rid of? - Paul S. Randal
http://feedproxy.google.com/~r/PaulSRandal/~3/vWj3chcto_I/post.aspx May 10, 2010 ... ... have the same effect as what Norton does to a hard drive. Not only will the database be shrunk to the smallest possible size, but all table ...
Help with performance - Debezium with SQL Server
https://groups.google.com/g/debezium/c/zGLGVJ4Xg8g Mar 7, 2024 ... I have around 140 tables that I need to replicate and currently ... All tables included, the size is less than 40 GB and the tables I ...
Get Table Metadata
https://sites.google.com/site/chilledsql/welcome/tables-and-triggers/get-table-metadata Get Table Metadata · Applicability: SQL Server 2000: Tested · --all tables, including system tables, in the database. SELECT · Get all System Tables: · /* The ...
Data/Database Compression - Compress all Tables and Indexes
https://sites.google.com/site/chilledsql/welcome/tip_category_compression/tip_detail_compression_compressalltablesandindexes Compression can be achieved via TSQL, but this can get a bit verbose where there are multiple indexes per table. The scripts below will generate TSQL ...
Quotas and limits | BigQuery | Google Cloud
https://cloud.google.com/bigquery/quotas Maximum size of stored data on Cloud Storage per external table, 600 TB, An external table can have up to 600 terabytes across all input files. This limit ...
Data/Database Size
https://sites.google.com/site/chilledsql/welcome/tip_category_dataordatabasesize Performance - Get SQL Server Uptime (and SQLAgent Service Status) ... - Retrieves a list of database sizes and objects counts for SPs, Tables, Views, UDFs and ...
Table sizes statistics | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/introspection/table-sizes-statistics TABLE_SIZES_STATS_1HOUR contains the sizes of all the tables in your database ... This section includes several example SQL statements that retrieve aggregate ...
Get Index Metadata
https://sites.google.com/site/chilledsql/welcome/tip_category_indexes/get-index-metadata Performance - Kill all Orphan Processes on a SQL Server · Performance ... Get all Tables in a Database with excessive indexes: --tables with more than ...
Code to list potential cluster key space savings per table - Paul S ...
http://feedproxy.google.com/~r/PaulSRandal/~3/eJw0Bsnpz70/post.aspx Feb 6, 2012 ... SQL Server Versions: 2005 onwards —————————————————————————— Written ... get mad at you when it inexplicably skips databases, that's all. :-).
Data/Database Size - Get Database Size and Database Object Counts
https://sites.google.com/site/chilledsql/welcome/tip_category_dataordatabasesize/tip_detail_dataordatabasesize_getdatabasesizeanddatabaseobjectcounts This SP retrieves a list of all active databases on a server along with database size (data and log combined) and the count of the number of code objects.
Dynamic Management View (DMV) Queries
https://sites.google.com/site/chilledsql/welcome/tip_category_dmvqueries Includes individual query statements. Get Unused Indexes - Returns a list of table indexes that have not been used since the last SQL Server Service/Instance ...
Error truncating performance_schema tables
https://groups.google.com/g/google-cloud-sql-discuss/c/KmXOjqkSwzk I want to collect data from performance_schema tables, such as "events_statements_summary_by_digest". However, this table has a max size and I think it will ...
FAQ | Datastream | Google Cloud
https://cloud.google.com/datastream/docs/faq Logical decoding exposes all changes committed to the database and allows consuming and processing these changes. For SQL Server, Datastream tracks data ...
DMV Queries - Get Average Data/Index Row Size
https://sites.google.com/site/chilledsql/welcome/tip_category_dmvqueries/tip_detail_dmvqueries_getaveragerowsize The code is reasonably well commented, but please note that there may be one or many rows returned for each table/index combination. From SQL BOL: For an index, ...
Use tables in Google Sheets - Google Docs Editors Help
https://support.google.com/docs/answer/14239833?hl=en Select a range of cells, either empty or with data. On the Menu Bar, click Format and then Convert to table. Select the appropriate column type for each column.
Data/Database Size - Get Data and Log File Sizes
https://sites.google.com/site/chilledsql/welcome/tip_category_dataordatabasesize/tip_detail_dataordatabasesize_getdataandlogfilesizes Central Management Server - Get List of Managed Servers · Clustering ... Auto-Create Update each Table TSQL Templates · Expand all TABs in a String to ...
Get Replication Details
https://sites.google.com/site/chilledsql/welcome/sql-server-migration-toolkit/get-replication-details Useful for identifying databases/tables on the source server that might be involved in replication. ... NOTE: Replication publisher can only be +/- 2 SQL Server ...
Data/Database Size - Get Index Size and Counts
https://sites.google.com/site/chilledsql/welcome/tip_category_dataordatabasesize/tip_detail_dataordatabasesize_getindexsizeandcounts To retrieve table and index sizes for all tables in a DB. Index and Statistics (ie '_wa_%') counts and index statistics update date are also included.
Downloading content | Looker | Google Cloud
https://cloud.google.com/looker/docs/downloading Yes. Microsoft SQL Server 2016. Yes. Microsoft SQL Server 2017+. Yes. MongoBI ... Select or leave unselected Expand tables to show all rows. If you select ...
Performance: DROP TABLE very slow on large tables
https://groups.google.com/g/h2-database/c/rVW-slB7KRY was due the server creating a new/rollback version of the table + ... noticed that during the proccess the DB files have grown in size by several ...