quote: I enjoyed the test...showed me a lot I didn't know. And a couple I didn't read closely enough (missed the UDP and 'assumed' it was TCP). When I was giving the same test to my team, 90% of them missed that question as well. I guess they ran through it too quick as well […]
2003-05-22
1 reads
Hi Frank, Sorry I didn't make it clear in my original question. It's a monthly batch job. I will get the date when the job run. What I am looking for is the last day for the month and the year of the date because I need to come up with year-mm-lastday in my WHERE […]
2003-05-21
Are you calling the SP from ASP or anything else? Have you grant 'NT AUTHORITY\ANONYMOUS LOGON' access SQL Server with proper permissions to tables in instance PROD1?
2003-05-21
Also, try running the query a couple of time, the provider doesn't always give the return error. Then finally can you post an example of what is failing, since you can see the tables some query is working.
2003-05-20
1 reads
quote: Check at http://www.cramsession.com/ to see what the most recent version of the test are. Thanks for your help, I will check the cramsession site. CSDunn
2003-05-20
1 reads
Thanks for the posts. I think IIS (local) is not marshalling ADO connection objects efficiently tying up things. This didn't occur until I started running IIS at the same time.
2003-05-19
I explain about how to break down the requirements for the MCDBA in this article: http://qa.sqlservercentral.com/columnists/bkelley/gettingcertified.asp Basically, there is a category for SQL Server Admin. You can either take the SQL 7.0 admin or the SQL 2000 admin exam in order to complete that category. That, the windows 2000 exam, and the elective will give […]
2003-05-19
Dinesh does a good write up on research he did investigating the BI market and doing a feature comparison between Oracle 9i and SQL 2000. Simple bullet point format, worth a look.
2003-05-19
19,264 reads
I definitely would notify MS and supply them as much information on this as possible. The very first paragraph on timestamp data type (BOL, Index tab, timestamp data type, then timestamp data type Transact-SQL reference) says: timestamp...guaranteed to be unique within a database. -SQLBill
2003-05-16
1 reads
I think the first step would be to identify the offending line of code within the function, and run it directly in the SELECT statement against the same subset of data that is producing the error, and then, using more WHERE conditions, attempt to drill down to the offending data...that is, of course, if you […]
2003-05-16
SQL is essential for modern businesses and applications that rely on data. It's a...
By Patrick
SQL Server Audit is an efficient way to track and log events that occur...
I presented at SQL Saturday Pittshburgh this past weekend about populating your data warehouse...
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