RE: Overall Scorecard ?
Not yet, Brian is still working on it. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-25
security
RE: DTS package won't run as job
I used my own account which was a sysadmin account using SQL Server authentication. I have a tip that problem might be resolved by stopping and restarting SQL Server. SQL Agent may not have access to all it needs to run job because it was started before Oracle Client install. I'll let you know if […]
2003-06-25
1 reads
RE: BULK INSERT
You need to use the value of the variable @file to create the dynamic statement i.e. SET @SQL = "BULK INSERT temp FROM '" + @file1 + "' WITH (FIELDTERMINATOR = ',') "
2003-06-25
1 reads
RE: BULK INSERT
SET @SQL = 'BULK INSERT temp FROM ' + @file1 + ' WITH (FIELDTERMINATOR = '','') ' exec (@SQL) Edited by - mromm on 06/25/2003 10:56:36 AM
2003-06-25
1 reads
RE: Best practice on table design
The other performance consideration, in addition to the efficiency of table scans as mentioned, is your cache hit ratio and I/0. More rows to a page, more rows potentially in the cache, obviously a good thing. And even when you do have to read from disk, if the more rows to a page, the more […]
2003-06-25
RE: How much do you earn?
"$100 is too much right now but when the economy is good, you can charge $100. Right now, the max you can charge is $50 an hour." Hey, I'd LOVE to make $5 /hour, or heck, even half that. I'm working as a DBA now for $11/hr and I'm doing hideous work. I don't do […]
2003-06-25
RE: How to make a SP stop automaticaly after s.time?
Hi, Sorry I haven't had time to test it, but the following maybe along the lines of what you need. -------------------------------------- declare @startdate datetime set @startdate = getdate() . . . if @startdate = datediff(mi, @startdate, getdate()) + n /*where n is the number of minutes you wish to timeout after*/ return -------------------------------------- Hope this […]
2003-06-25
RE: How much do you earn?
Interesting topic! Well the UK market depends a lot on where you are. You can earn between £25k & £60k a year in London. The further north you go, the salary drops and mostly I have seen top ends of £30k. I'm on just under £30k which is about $50 or 43,000 euro's! Most of […]
2003-06-25
1 reads
RE: Ora-01652: unable to extend temp segment by
Steve and Henry, Thanks for the replies. Indeed the model is not ye optimized because it was just for some (quick) testing to find out what are the limits. Perhaps we should take this in notice. I don't know how big the DB in Oracle is. I can ask the DBA. Regards, Bart
2003-06-25
1 reads
RE: sql server logs are not being filled
Maybe there's nothing to be logged. No jobs being killed, and possibly no backups happening because SQL Agent not started? Could you have cycled SQL Server and forgot to restart SQL Agent? From QA try: RAISERROR ('Hello World', 0, 1) WITH LOG Then: exec sp_readerrorlog You should see your "hello World" at the end of […]
2003-06-24
Blogs
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Monday Monitor Tip: Compliance Checking for Old Versions
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
Making Legend Order Match Segment Order in a Power BI Stacked Column Chart
A reader of one of my previous posts pointed out that the legend order...
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