2018-06-05 (first published: 2018-01-11)
2,138 reads
sys.objects
Display the SELECT statement for any table
Found this lovely T-SQL script to display the SELECT statement for any table.
2013-08-22 (first published: 2013-08-06)
3,211 reads
Change Monitor in SQL Server 2005
Track object definition or table schema changes in any database. Batteries required: you need to create a few things to make it run.
2010-05-14 (first published: 2009-06-24)
1,706 reads
RE: Curious Locking
Thanks for that..had a look.The execution plans were identical.I tried varying the indexes on this table. One index in particular was dropped and it cured the problem....the query now runs in about 5 minutes instead of an hour. Funny thing is the same indexes exists on a similar test system and that runs ok??Thanks again..Graeme
2005-03-11
Linked Server Issues with Oracle 8.1.7
Hi ,I have a scenario where I need to configure a linked server on SQL 2000 Ent. Edition which connects to a Oracle 8.1.7 database. The linked server will be used in distributed transactions as well.I have done Linked Server Setup, and it is working correctly. I am worried about few things in this.1. Will […]
2004-02-23
4 reads
RE: How to... Change a Filegroup for an Existing Table
Using EM? I was hoping for something similar to ORACLE, which allows you to move objects to new filegroups/tablespaces using the ALTER syntax for the given object type ie: table/index. Maybe Microsoft is changing this???Thanks everyone for your help ...
2004-02-20
RE: sp_spaceused tablename for each database
Thanks.. that is EXACTLY what I'm looking. Now my only issue is putting the info into a table. Every time I try an insert I get an error message that says Server: Msg 8164, Level 16, State 1, Line 1 An INSERT EXEC statement cannot be nested. Server: Msg 8164, Level 16, State 1, Line 1I've […]
2004-02-19
2003-06-19
2 reads
RE: controling script
Build two SQL Server Agent jobs. One that executes SP_2, and the other executes SP_3. Then have SP_1 start the SQL Server Agent jobs by using the sp_start_job SP.
2003-06-19
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