RE: Transaction Log
Derrick is correct. unless you are getting "transaction log full" errors, in which case the NO_LOG option will work.
2004-05-25
automation
RE: Perfmon output: Converting from binary to CSV file
Hi bj007, "Is there something i am missing.." After you click on the fourth button, "View Log File Data" or CTRL-L, you should all all of the instances of all of the counter, of all of the objects. To do this. * Click on the eight icon from the left (the plus sign, "Add", […]
2004-05-18
RE: How to Compute Actual Space Used In Datafiles
Have to add my two cents... DECLARE @DBName nvarchar(60) DECLARE @SQLString nvarchar (2000) DECLARE c_db CURSOR FOR SELECT name FROM master.dbo.sysdatabases WHERE status&512 = 0 CREATE TABLE #TempForFileStats([Server Name] nvarchar(40), [Database Name] nvarchar(60), [File Name] nvarchar(128), [Usage Type] varchar (6), [Size (MB)] real, [Space Used (MB)] […]
2004-05-06
RE: "sqlmaint.exe failed" when using xp_Sqlmaint
Right-click on the maintenance plan and select "Maintenance Plan History". This is where you'll find much more descriptive error messages.
2004-05-05
RE: Using Query Analyzer Templates
Thanx for the article. But when i tried to create this template, the table created in master database instead of DEMO_DB. Could u explain abt that in detail? Thanx again.
2004-04-28
SQL Server 7.0 Agent fails every once in a while
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-26
Any known issues using Access with SQL Server
Hello,I'm currently learning SQL Server and have had years of experience with Microsoft Access. I've heard from several DBAs that using Microsoft Access to retrieve data from SQL Server can cause issues on the server. I'm trying to get more information on specific types if issues seen so I can document them for our support […]
2004-04-21
1 reads
String Manipulation
Hello, I've got a stored procedure written that will send a query to a Finger server and return information about a person. Currently, I get the person's name like this:Smith Joe R. I would like to reformat this within the sp to read:Joe R. Smith or even break the name down into three separate fields. […]
2004-04-15
RE: Duplicate Records Being Inserted
Others gave you the reason why this occurs, but the way to avoid this situation would be to key off another field within the table and check against sometype of timestamp datetime field and a customer id type to see if a particular customer has within a relativly short timespan (e.g. within a few seconds […]
2004-04-13
Best Option to Replicate Database?
We have a database that consists of a number of static tables, several tables that are rebuilt from scratch every night, a couple of SP's and a gazillion views. Currently it resides on a old SQL Server (old hardware, current software) and I'd like to migrate it to a newer High-Availability Clustered SQL Server environment our […]
2004-04-06
1 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