Execution Logging

Technical Article

RE: Cursor not working

  • Reply

quote: These guys are right. You don't need a cursor to do the update. Also, let me suggest that you wrap the update statement in a transaction. BEGIN TRAN...COMMIT TRAN. When you are ready to run the code, use begin tran and the update statement without the commit tran. You should see how many records […]


Technical Article

RE: How to know when File is done FTPing?

  • Reply

Check the file size. One minute later check it again - if same, you can assume its finished. If you aren't on a fast network then stretch it out to five minute checks. Another alternative is to not use the FTP object, instead running a batch file that does the ftp then as the next […]


Technical Article

RE: awe (Address Windowing Extensions) on S2K SP3

  • Reply

To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege. To obtain the correct amount of SQL Server memory usage, you can use the Total Server Memory (KB) performance counter, activated through System Monitor, or […]


Technical Article

RE: SQL Server Considerations

  • Reply

Dear pro2003, My first question is - what're we gonna call you in 2004? ok - here's one guy's humble opinion: #1: listen to mccork on hardware - very important - get a REAL server... #2: ram on pII machines is cheap, ram on REAL servers is not - you might have to fight the […]



Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers