I think a nice analogy to think of is how texts are translated. If you would take an English text and start translating it into another language, Swedish for example, and just translate it word by word you would get a very weird result. It might have the same basic meaning, and it would probably […]
2005-04-21
SA may not be the only login that can perform a backup. Backup permissions default to members of the sysadmin server role and the db_owner & db_backupoperator database roles. If there's a login in one of those roles that you know, use it to do the backup.If you do a search on this site for […]
2005-03-16
Hi All.Can someone please tell me how to empty the transaction log without doing a backup - restore - shrink or a transaction log backup.I want to empty it as it is a test DB and I am not interested in restoring if there is a problem with it.Thanks.CCB
2004-12-10
I already know without char(10) or next line or everything in one line get attacked. Is there way to break when char(10) is there?The problem in not using dynamic SQL is Complexity and app is already running. I don't want ot mess arround if there is no risk.
2004-12-02
Well,I don't have an answer(!) But you've got several variables here, and you might investigate this phenomenon further by exploring individual scenarios one-at-a-time (at least that's how I'd try to attack the problem). For example, investigate:(1) The number of returned rows: Try switching your query to something that returns a small number of rows (say less than 100 rows or so). Any differences observed?(2) The number […]
2004-08-24
Hey Gopal:You can even try this. Its very funny that sometimes u can laugh at the way you have written the query when u look into that after sometime again in the future.select (rtrim(col_a)+','+rtrim(min(col_b))+','+rtrim(cast(max(vol) as varchar(10)))) as Final_Result from testtbl group by col_aResult is:Final_Result -------------------------------- A,B,10 AA,B,23 AAA,B,45This is the Modified Statement of my previous ones..Isn't […]
2004-03-23
Sorry I haven't had a chance to play with SQLCE but are you saying your trying to attach to .sdf with EM from desktop or within CE device. See if this helps any http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road05222002.asp
2004-03-22
Thanks for the advice. The only part I did not understand how to accomplish is using the CASE statement to create the ORDER BY clause. I'd love to see some sample code of that process. Thanks again for all your help. This is an awesome place for SQL help! It is much appreciated. I've learned […]
2003-08-31
quote: This is rediculous. Why do I have to be absolutely dependant on an e-mail server's 24/7 availiability in order to get email from SQL Server? At any time, exchange can be down. If it is, SQL Mail quits working correctly. This is completely unacceptable. Jeremy, you don't need the sleep. Just monitor 24/7 from […]
2003-08-24
1 reads
Also check if any non-logged operations (select into, truncate table, etc.) occurred. This always broke log shipping at my office and sometimes the only way to get it going again was to perform a full backup and restart all the shipping.
2003-08-13
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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