Tame Those Strings - Part 9
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2002-04-04
7,641 reads
Advanced Querying
Auditing Your SQL Server Environment Part I
Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.
2002-04-02
10,420 reads
Account Balance
I have a fact table that holds the Bank Account Balance on a daily basis. I created a cube and included this Measure. I want to define the following aggregation for Bank Account Balance: "Sum across Non-Time dimensions and Closing Period across Time Dimension" I could use the formula ([Measures].[Account Balance],ClosingPeriod([Date].[Day],[Date].CurrentMember)) but then it will […]
2002-03-27
1 reads
DTS - SQL - Text
I have created an Execute SQL Task in my DTS package to query for a record in my new table. What I need to do is take the result of that query and create a text file of it. Note there will only be one record found in my SQL Task. I will then take […]
2002-03-26
1 reads
6.5 DB has ' Loading' Legend on Ent. Manager
Hello, I created a 'restore' DB (FOR LOAD) so I can test my backup. It was created on the same (and only) production server. This DB I created has another name than the original, but the same size for devices (Data and log separated). What happens is that after creation Enterprise manager shows the DB […]
2002-03-22
2 reads
Delete Secondary Transaction Log
I have inherited a SQL 2000 database that has 2 transaction log files defined for it. I would like to eliminate one of the transaction log files since the first one that was defined has plenty of disk space and the second file that was defined is on a disk with limited space. When I […]
2002-03-22
How do I check the last time a table was touched
I have a table and need to perform a low cost query to find out the last time an insert occured. I cannot query the table directly as it is very large. So am seeking the information either through the system tables or sql command. Anyone?
2002-03-22
DTS Execution and Security
Hello, I have a user login account that has db_owner rights over a single database on a development server. I want to give this user the ability to refresh/overwrite the contents of this development database with a copy of production. They need to do this on-demand. To do this, I created a Local DTS package, […]
2002-03-21
2 reads
Locking - Needing a few tips
I have a system that updates adds a new row to a table and updates an existing row in a seperate table for an in house auction system. Basically I have an items table which contains the items and the last bid and the last bidder. I then have a bids table which holds the […]
2002-03-21
SQL Server Errors and ODBC Errors
I have a stored procedure that does a simple insert into a table. The procedure is called from Cold Fusion and even though I am trapping errors in the procedure, ODBC displays its own error message immediately and Cold Fusion never receives the error message that I am returning from SQL Server. How can I […]
2002-03-21
1 reads
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