2008-09-09
1,057 reads
tables
The Ultimate Table Searcher
Searches for tables who's names contain the search string. Gives Size and Rows information as well.
2009-10-14 (first published: 2008-08-01)
2,226 reads
The Ultimate Column Searcher
Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.
2009-10-16 (first published: 2008-08-01)
1,432 reads
Table Information View -- No Cursors!
Row counts and storage space information for all tables in the database. (SQL Server 2005).
2013-12-26 (first published: 2008-03-16)
16,607 reads
RE: Making a copy of a sql table within same DB
I don't think Select Into configures indexes and keys.You may want to script the table first with all keys and indexes but WITHOUT Drop Table option so you would not accedentally delete your original table, in the script replace a table name with a new name, run the script to create a new table. The […]
2005-04-11
Create Synonyms
How can I create synonyms for tables in a database and give a user read only access to those tables. I don't want to use the schema name before querying the table as that read only user. ThanksAnu
2005-04-11
RE: Force Order
Forgive my ignorance, but why do you store such redundant data like a running balance in your db at all? The usual approach is either use something like this:IF OBJECT_ID('lfdsum_t') IS NOT NULL DROP TABLE lfdsum_t GO CREATE TABLE lfdsum_t (col1 int) INSERT INTO lfdsum_t values (1); INSERT INTO lfdsum_t values (2); INSERT INTO lfdsum_t […]
2005-04-07
XML Bulk Load - getting the XSD
Hi all, I am trying to get this damned SQL XML Bulk Load to work and I have found that I can pass the ADO command to load it into the database.The 2 parameters I need are:1.) The XSD2.) The XML file to importThe problem I have is that the XSD file I have is […]
2005-03-29
RE: Default Transaction Isolation Level
There are 4 types of transaction isolation levels. Here is the syntax :SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | READ UNCOMMITTED | REPEATABLE READ | SERIALIZABLE }Once you set the Isolation level, it will work for that particular connection.--Kishore
2005-03-29
2005-01-05
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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