RE: service pack 3a upgrade sqlsp.log
Okay. Thanks again for the important info on the security patch. Juanita
2004-05-26
Analysis Services (SSAS)
RE: Just a simple question
One very important thing to remember: RESTORE the database using WITH NORECOVERY, the RESTORE the first log WITH NORECOVERY, then the last log using WITH RECOVERY.Oh, second thing to remember....if your database 'goes down', try to backup the current Transaction Log. If you can back it up, you can RESTORE it last using WITH STOPAT […]
2004-05-14
RE: Report Preview
The performance is NOT slow. It is in the design/layout mode when laying out the report that it is slow(insert more detail lines or whatever). I can mess around with the report changing properties like hiding a group header and all of sudden I will get the whole report in the Print Preview. However, I […]
2004-04-26
RE: DTS Package fails when SCHEDULED (Only fails with non-MS dbs / drivers)
Unfortunately no improvement. I tried using both an ODBC connection and an OLE DB connection to Interbase, both failed when scheduled but succeeded when run through SEM.THe OLE DB connection returned the following error:Step Error Source: LCPI.IBProvider.2 Step Error Descriptionatabase connection failed. SQLCODE=-904: unavailable database IBCODE=isc_unavailableStep Error code: 80004005 Step Error Help File: Step Error […]
2004-04-23
RE: Question of the Day for 09 Apr 2004
Why, because some people are lazy and/or careless. I have found on development servers with user objects in all of the system databases. More often than not, they were put there by my manager who insists on sysadmin rights, but doesn't have a clue otherwise.
2004-04-09
RE: SELECT INTO with stored procedure result set?
Thanks Jack,As it turns out I'll be moving to SQL 2000 very soon now, so this will become useful almost immediately. I'm running tests this week.
2004-03-30
RE: sql injection articles
The other benefit of this is that it is the most performant way of calling an SP. The mechanism allows the SQL engine to very efficiently produce the parameterised query that is used to determine reuse later on. i.e. two calls using this method are more likely to reuse the sam equery plan. Unlike two […]
2004-03-29
join 3 tbls
I have a case like this:table a - has one filed with statusIDtable b - has one filed with statusIDc - status code tbl - statusID(int,4), status Decription (char, 20)When I want to pull the description for the statuses I have in "a" and "b" for a particular custID (they will be always different) I could use:select * from a […]
2004-03-24
3 reads
RE: Jobs still run, even when DISABLED
Acutally no if Job is enabled and schedule is not it will not automatically run, also same vice versa. However even if both are disabled then it has to be initiated by an external process to the job itself (User, another job, code in a page, another server, etc).
2004-03-23
RE: Change word that r in upper like the Excel function proper
Or you can use this function, which I did post in the Scripts section, but since the website upgrade, for one reason or another it no longer comes up in a search. /*This function will evaluate an input string and convert it to title-case format. it uses the delimchars parameter to determine what are the triggering […]
2004-03-21
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