2005-03-03
3,246 reads
Miscellaneous
When the last time Database used
This Procedure will display info regard to when the last time database was used. How to use it--------------Exec master.dbo.Sp_LastTimeDBUsed 'pubs'
2005-03-15 (first published: 2005-03-02)
1,068 reads
Stored Procedure Call Hierarchy
Easily extractss the complete stored procedure call hierarchy from "sysdepends" table of SQL Server and represent it in a pseudo-graphical tree-view.The script uses a temporary table (automatically created/dropped) to hold children and parents of relationships. For representing the call hierarchy the table contains a level field (depth) and a field containing the "enumerated path" (using […]
2005-03-14 (first published: 2005-03-01)
4,031 reads
PASS Summit 2005 Deadline for Abstracts Approaching
THE DEADLINE FOR SUBMISSIONS IS MARCH 4, 2005. Don’t miss your chance to be a part of the largest educational event exclusively dedicated to SQL Server! The 2005 PASS Community Summit in Grapevine, TX offers a great opportunity to both share your experience, tips and techniques with fellow SQL Server professionals and to solidify yourself as a SQL Server expert. You can share the stage with user-experts from around the world, a host of MVPs and many key members of the Microsoft SQL Server development team who are participating at the PASS Community Summit for one reason – to enrich and inspire the user community.
2005-03-01
697 reads
Interviewing With a Dud
Looking for a new job? Trying to move up the career ladder and gain another position? This article is not SQL Server or DBA specific, but Steve Jones takes a look at the actual interview. The interview where the person conducting the interview is not prepared and what you can do to shine.
2005-03-01
10,651 reads
Review: Access Workbench
For some years, I have been asked to review a product that I have only just gotten around to looking at. It was developed by Garry Robinson, who publishes a very useful web resource called vb123.com and who recently wrote one of the best books on Access security, Real World Microsoft Access Database Protection and Security. The product is called The Access Workbench (TAW)
2005-02-25
2,359 reads
BCP all user tables of a database
This script will BCP all user tables of a database to individual files. The file names are tablenameyyyymmddhhmmss.dat To executeusp_bcp_out_alltables 'database','path','server'You will need to change your default 1) path2) server
2005-03-07 (first published: 2005-02-23)
287 reads
Remove multiple whitespace from a string (alternat
Here's an alternate way of removing multiple white spaces by using the REPLACE command.
2005-03-08 (first published: 2005-02-22)
178 reads
Performance Tuning Tips for Using Microsoft Access
If you are really interested in the fastest performance, don't use Access as a front-end to a SQL Server database. While Access is relatively easy to learn and fast to develop in, its performance if poor when compared to other front-end options. But if you like to develop in Access, or don't have any choice, then the tips on this page will help a little to boost your application's performance.
2005-02-22
3,035 reads
2005-03-09 (first published: 2005-02-21)
200 reads
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers