Total Database Information At Your Fingertips Part - II
This article will help to get some basic information from your databases that may help you in different situations.
2011-11-24
5,458 reads
database
Using The Kimball Dimensional Modeling Tool
Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.
2011-10-31
8,079 reads
sp_MSforeachtable:Add SQL objects to multiple database on a server.
ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.
2011-11-14 (first published: 2011-09-19)
646 reads
SQL Server System Report
Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.
2019-04-15 (first published: 2010-05-11)
15,325 reads
RE: Data in two tables
Hi Sushila,suser_sname() prints the same user as user_name().Here is my trigger:CREATE TRIGGER [track_time] ON dbo.ATTENDEES FOR UPDATE AS UPDATE ATTENDEES SET timestamp1=GETDATE(), User_name1 =suser_sname() FROM ATTENDEES JOIN deleted ON ATTENDEES.FTKey=deleted.FTkey AND ATTENDEES.Day1<>deleted.Day1
2005-05-30
RE: DTS Package Object Model
ok, here it is: Its not perfect, but it works.This is part of my code, so let me explain. The important stuff is highlighted. You have to get a hold of your Task object from the particular package object that contains the TransferObjectTasks. One bad part that I can't figure out is how many objects there […]
2005-05-24
RE: How to find default object in the systables?
Thank you Wanderer, the SQL statement was exactly what I needed!
2005-05-24
RE: Date Conversion
This is a cool date format function I found a while back. See header comments for credits.../* ////////////////////////////////////////////////////////////////////////////////// Author: Rusty Hansen 8-21-2001 Description: Formats a date to a specific format. Parameters: @dDate = A value or field of datatype datetime or a value or field that can be explicitly converted to a datetime […]
2005-05-20
RE: what exactly are cursors, the actual mouse pointed in client app?
The database cursor is an acronym for CURrent Set Of Records (or Rows). The mouse cursor is derived from the Latin word for "to run" (http://www.etymonline.com/index.php?l=c&p=33) and is an extension of the name for the sliding part of a slide rule or other instrument. Two words with the same spelling but completely different meanings and […]
2005-05-05
Unable to create Publication
Hello,I am having a strange problem. I am unable to create ANY new publication on any of the databases. I try to add it using the SQL Enterprise Manager or Query Analyzer and get the following error for exec sp_addpublication :Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24 Supply either @job_id or @job_name […]
2005-05-03
3 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