RE: How much do you earn?
Hi all, tired of asking frequently what is this acronym, what means that I've found this link http://www.acronymfinder.com Cheers, Frank
2003-06-23
1 reads
security
RE: Upgrading our SQL Servers
Direct to 2000. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-23
RE: JOINS - int vs. varchar performance
Thanks j.o.s. I was looking for that myself. I know that it has been said that there is no difference between comparing varchar and int's but in fact it is a size matters issue as pointed out.
2003-06-23
1 reads
RE: Nested transactions in nested sprocs- possible?
The answer to your last question is yes. Commit and Rollback are alternative ways of closing a transaction. Once you have rolled back (or committed) a transaction, there is of course no transaction outstanding. So if you issue the 'COMMIT' command, SQL Server will protest that there is nothing to commit. In the case of […]
2003-06-23
1 reads
RE: eliminating duplicates from stored procedure joins
Ah! Thought that might be the case. Are u getting full row duplication or only a few columns? Can u be more precise as to what is duplicated? Which columns? Can u post some data (non sensitive) that shows the duplication and what u want it to look like without duplication. If data too large, […]
2003-06-23
RE: The Scheduled jobs (6.5) suddenly started failing
MarkusB, Thanks for the reply. Still stuck the problem The Login Security Mode has always been Standard. (the default). This is what is puzzling about this as I do not know of any server changes or access rights modifications. I checked the loginmode - it is set to 0 regards Bill
2003-06-22
RE: Lost the MDF, have the LDF
Actually, I was assured by the NetAdmin that my server was being backed up (the partitions that hold my MDF's and LDF's) as part of the backup sets with the rest of the network. The lesson I learned is that I should have been managing my own backups, not relying on someone else to do […]
2003-06-22
RE: Problem with arithabort
do u make restart for the whole copmuter and server !! may be this solve the problem. any way .. I think i have face this problem before .. and when I get an old backup and restore it on server .. it works !!! so sometimes this error is a funny error (Ad-Hoc problem) […]
2003-06-22
RE: Moving SQL 2000 to new array
The big thing here is that we are NOT moving SQL to new directories, new drives letters, etc. We are just moving to a new set of hard drives that are being built the exact same way the original ones are set up. So, I'm thinking stopping services and just copying the data over will […]
2003-06-21
RE: Concurrent restore
Do you mean you want to restore the same database to multiple servers at the same time? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-20
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