RE: TRANSFORMING DATE USING DTS
Put your delete code inside a stored procedure and call the sp from the Execute SQL Task, passing in the date value as a parameter. Diane
2003-07-31
PowerShell
RE: Convert varchar to numeric
One way to go around this problem is to get the number directly from Progress as opposed to you converting it. You can use To_NUMBER Progress function. The function will convert the Char_expression to a number. for example: you can have the following: SELECT * FROM customer WHERE TO_NUMBER (SUBSTR (phone, 1, 3)) = 603 […]
2003-07-30
RE: delta processing: alternative to cursor
Jeremy, There may be some things in your SQL that we could look at that might speed things up. But aside from that, speed is not the only problem with CURSORS; they can also have serious memory problems associated with them that a SET-based solution usually doesn't. That said, there ARE times when a cursor […]
2003-07-30
RE: Single User Bug????
quote: ...Is there any possibility that DBCC is trying to fix some minor errors, and SQL Server changing to Single User Mode & not changing it back?! Just a Thought.... That is EXACTLY what is happening. When you check "Attempt to repair minor problems" under the Integrity tab, the maint plan job will try to […]
2003-07-30
RE: Poor login speed with 2000+ tables
jfrank, it sounds to me that it is something specific to your application. you can investigate more and find out exactly where the login process is waisting so much time by profiling the server, save the trace and run it in QA; there you can see the query plan in detail and find out exactly […]
2003-07-29
2 reads
RE: IDENTITY Info in System Catalog
But how do I figure out if seed and increment were specified explicitly or not? For example, CREATE TABLE tbl_1 ( col_1 INT IDENTITY ) versus CREATE TABLE tbl_1 ( col_1 INT IDENTITY( 1, 1 ) )
2003-07-29
RE: Indexed view and EXCEPTION_ACCESS_VIOLATION
Sorry, result of DBCC CHECKDB was:- CHECKDB found 0 allocation errors and 0 consistency errors in database.
2003-07-29
1 reads
RE: Doing Short Circuiting in WHERE clause
Thanks guys....exactly what I was looking for. Man, this is a great place to learn from.
2003-07-28
RE: How to change default Protocol on SQL 7
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!
2003-07-28
RE: Doing Short Circuiting in WHERE clause
If @FirstName and @LastName are the variables and contain NULL for 'Not Supplied' then WHERE (@FirstName IS NULL OR @FirstName = FirstName) AND (@LastName IS NULL OR @LastName = LastName) or if you want to test in sequence then WHERE (CASE WHEN @FirstName IS NOT NULL AND @LastName IS NOT NULL AND @FirstName = FirstName […]
2003-07-28
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