I have applied a trigger on inserts of a table. The triger might execute for 10 or more seconds depending upon the data in the table. The trigger might affect other tables as well. When a record is inserted into the table, the triger fires and starts executing. Now suppose that as soon as the […]
2004-01-29
sometimes the best solution is the simplest CREATE PROCEDURE Usp_MoverItemTest1 (@id char(1),@Direction char(1)) As SET NOCOUNT ON DECLARE @sort int, @id2 char(1) SELECT @sort = sort FROM testsort WHERE id = @id IF @direction = 'U' BEGIN EXEC usp_moveitemtestup @sort , @id2 output END IF @Direction = 'D' BEGIN EXEC usp_moveitemtestdown @sort , @id2 output […]
2003-12-01
1 reads
Should be doable. Access supports both autoexec and named macros as I remember, you just pass a command line switch. I'd suggest using a batch file to get it to work right, then either call the batch file directly from the job or cut/paste the line from the bat into the job. Most likely what […]
2003-08-25
Once again thank you Frank. Do you think it would be possible to get the users to trasport the data from an excel spreadsheet to the database every time a new product price list comes in? Or would it just be easier to create an application that they would have to manually enter new prices […]
2003-07-15
Since ur using 3rd party util, better verify it with your vendor whether their interpretation is the same. I am not sure whether your vendor is using SQL Server commands to backup the db or not, or maybe they have their own system just like SQL BackTrack. SQL Server though use the term 'Differential' Backup.
2003-06-17
Haven't used them, but they are around the corner from me and hiring SQL DBAs. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-17
Sounds to me like you are using it correctly. You may want to look at the queries that are using indexes that you think are not correct and review the joins/where clauses. It may be a simple re-arrangement of the where to start using the proper indexes. Good Luck AJ Ahrens SQL DBA Revenue Assurance […]
2003-06-05
2 reads
This was the last entry into the SQL Log sqlagent 110-328 EXIT SQLGetDiagFieldW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 3 SQLHANDLE 006A2A58 SQLSMALLINT 1 SQLSMALLINT -1154 SQLPOINTER 0x00E19170 SQLSMALLINT -6 SQLSMALLINT * 0x00000000
2003-06-05
1 reads
IOs aint IOs. There are two physical types of IOs - direct and sequential - and other terminology depending on what function you are using to look at it. Firstly, the popup information in a query analyzer plan is always an estimate, even the "actual" plan. If you set ConnectionOptions ShowIO, you get logical, physical, […]
2003-05-26
At this point, I'm scratching my head. The system is handling authentication just fine... this would seem to indicate that there's a potential problem with SQL Server, one I've not seen before. When you try and log on to the SQL Server using QA and using Windows authentication, are you able to log in (you're […]
2003-05-20
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers