RE: Getting column types.
I guess, but how can I limit my query. I only want to query for a specific table and specific columns.
2002-03-18
2 reads
SQLInsider Scripts
RE: Size of Log Files and TempDB
Not sure I agree about setting a max size, maybe because Im in a small company and can run a looser ship! One thing I do though is keep a junk file on the drive just in case - should I ever run out of space I can delete it while I clean up. Andy
2002-03-18
RE: Getting column types.
Looks about right, but the system tables could change in an upgrade. Information_schema views are standard views that will stay the same. Steve Jones steve@dkranch.net
2002-03-18
1 reads
RE: Size of Log Files and TempDB
First don't worry too much about tempdb it pretty much lives it's own way. I usually leave dynamic with a minimum of what I know a weeks growth will be (I do a full backup weekly). At that time I do several processes and truncate the file and shrink back to the size I had […]
2002-03-18
RE: Getting column types.
After about 2 hours I have come up with this: select c.name AS ColumnName, C.Type, T.Name from sysobjects o, syscolumns c, systypes t where o.id = c.id AND o.type = 'U' AND c.xtype = t.xtype
2002-03-18
1 reads
RE: Getting column types.
Do I have a way to view the TSQL. I am trying to join the syscolumns, sysobjects and systypes now 🙂 Neil
2002-03-18
1 reads
Get BCP out for all tables in a DB
The script mentioned below will export data in all tables into textfiles to a physical path on your system using BCP utility from a Database. The sql commands used in this stored procedure are BCP utility,Identity function and temporary tables. Here you required to give 4 input parameters, they […]
2002-03-15
1,838 reads
Display Row Count for all Tables
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
2,827 reads
Script to list user tables with related procedures
This script interrogates the system tables and provides a list of user tables with related stored procedures and triggers. Alternately, reordering the temporary table provides a list of stored procedures with the table names used in each procedure.
2002-02-18
356 reads
SP to show information about log in databases
It calculates log free space in mb and in percent for all databases, and also show the quantity of different objects for one databases.
2002-02-02
2,723 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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