The Ultimate Object Searcher
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
2009-10-06 (first published: 2009-09-22)
1,255 reads
Scripts
2009-10-05 (first published: 2009-09-21)
2,292 reads
The Ultimate PK-Less / CLIDX-Less Table Finder
Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.
2009-10-02 (first published: 2008-11-05)
1,206 reads
BCP command to export data to excel with column headers
This script export data into excel/CSV file using BCP comnand with column headers
2009-10-01 (first published: 2009-09-22)
3,607 reads
Execute SQL Scripts in paralel for real performance tests
Ever tried to simulate a production environment in a development one but realized that you couldn't easily start 500 executions simultaneously ? This script will help you out.
2009-09-30 (first published: 2009-09-16)
2,107 reads
2009-09-29 (first published: 2009-09-17)
947 reads
Runaway Job Management
Be alerted or take custom actions when specified jobs are in the "Running" state for a length of time.
2009-09-25 (first published: 2009-09-15)
941 reads
2009-09-24 (first published: 2009-09-15)
718 reads
Shrink Log File to Target Percentage
Performs a checkpoint or a transaction log backup followed by a DBCC SHRINKFILE on the transaction log to the target percentage specified relative to the total data file(s) size.
2009-09-23 (first published: 2009-08-27)
2,571 reads
Generate Data Script for a Table
This script takes a table as parameter and generate its data script (INSERT INTO TABLE).
2009-09-21 (first published: 2009-09-13)
2,291 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers