RE: No email of posts any longer
Brian - we'll work on that. No forum wide subscription either I think. Frank - the message is just so you dont miss the old forums too much!
2004-01-05
security
RE: Do the certifications add value?
I don't think the certified person will get the benefit. I just see that, the person, who has a knowledge will be get the earlier priority than other. Prashant Thakwani thakwani@rediffmail.com
2003-12-31
2 reads
RE: Network error
quote: What are you doing that requires network access? K. Brian Kelley, GSEC Brian, thank you for the good question. Some of jobs are running very simple queries on local SQL Server. But I would like to beleive that I found the trace. Some of the databases have owner different Active directory and local server […]
2003-12-30
RE: qod 12/29
Thanks for the input. I am learning much from this forum. I didn't consider that it might work if varchar, since most of the tables I work with use char() fields. I have on more than one occasion tested an update query similar to what is being attempted here to find that if I had […]
2003-12-30
1 reads
RE: Generate Sequence Number Safely
quote: jxflagg, could you show me how to use temp table and update lock? Not a temp table, a real table. Like this: CREATE TABLE [Exp_UniqueKeys] ( [Table_Name] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [last_key] [int] NOT NULL CONSTRAINT [DF__Exp_Uniqu__last___515009E6] DEFAULT (1), CONSTRAINT [PK_UniqueKeys] PRIMARY KEY NONCLUSTERED ( [Table_Name] ) WITH FILLFACTOR = 90 […]
2003-12-30
RE: Free space in Data file
To see the log space usage you can use dbcc sqlperf (logspace) sp_spaceused reports only the data and index space usage (in the reserved, data, index and unused columns) and this is what you want I guess. Only database_size column combines the file size of the data AND the log files. Bye Gabor
2003-12-30
1 reads
TSQL Virus or Bomb?
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
2003-12-29
5,760 reads
RE: Need ActiveX Script To Rename A File
Here is a variation of the above if you want to control the move more precisely by separating the copy and delete portions into separate ActiveX tasks. ActiveX Task 1: '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Orig_FileNm = "C:\SourceFile.txt" Dest_FileNm = "C:\Folder\DestinationFile.txt" Dim fso Set fso = CreateObject("Scripting.FileSystemObject") IF (fso.FileExists(Orig_FileNm)) THEN fso.CopyFile […]
2003-12-23
1 reads
RE: Need ActiveX Script To Rename A File
http://www.sqldts.com/default.aspx?292 Quoted from above article. "Move or Rename File This shows a simple file move operation, using hardcoded source and destination filenames. There is no explicit rename method in the scripting object, but a move is just the same. ' Move File Option Explicit Function Main() Dim oFSO Dim sSourceFile Dim sDestinationFile Set oFSO = […]
2003-12-22
1 reads
RE: Memory Management
There is 1 GByte of Ram and the vendor set a fixed size of 0.5 GB. There are no other applications running on the server so I would have expected that this would reduce the amount of memory available to SQL Server.
2003-12-20
1 reads
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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