I am using the domain administrator account for the SQL agent startup as indicated on services...I have also verified that the administrator account has the owner role given to it under the roles section of this particular database in Enterprise Management Console...This user account has full rights to the \\backupserver\share\path that I wish to back up […]
2004-04-12
How i can have this? do have any example about extend stored procedure?I'm not an expert in sql server, i'm expert oracle
2004-03-11
by the wayHmm... but does that clear the on-disk compiled versions of the stored procedures as well?
2004-03-10
I have a server running SQL Server 2000. There are about 10 databases on this server. The response time of the application using these databases is very slow. How can I troubleshoot within SQL Server to determine which database is causing this problem? How can I tell what stored procedures are being used and how long […]
2004-03-03
1 reads
Validating user input is really not complex at all. If you need to build and execute ad hoc queries you just need to remember two things.With strings, always replace ticks/single-quotes (') with two ticks/single-quotes ('') <- notice there are two characters there and not a double-quote ("). If you do this then the user entry for […]
2004-02-24
Triggers fire per transaction not per record. WIth the INSERT...SELECT the whole piece is one transaction which means all the items are in the inserted table at one time when the trigger fires. As I said with the @var = column in a select the @var reads in each value as the buffer is read […]
2004-02-11
I have created a partition view for testing. When updating 1500 rows it takes over 4 minutes using the view. When updating using the base table it takes less than 30 seconds. Any ideas? How can anyone be using these for distributed large databases if the updates run significantly longer? I am currently using these […]
2004-02-04
4 reads
Chris,Excellent article!!! After reading your article, I checked w/ our Sr. System Developer to verify if we are using these techniques. We are looking in depth to other exploitations of SQL injections with our app.Thanks,Dave S.
2004-02-03
quote: I agree, I did not answer the question because it did not include changing the dateformat for the imports from overseas using set dateformat dmy, and set dateformat mdy for the US imports. But like any question (even the MS Certifications), the correct answer is always (okay, it's supposed to be) the BEST choice […]
2003-12-19
Did your network folks block UDP/1434 per chance? K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-11-21
2 reads
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