2014-09-29 (first published: 2010-02-04)
9,301 reads
Partitioned table
RE: Moving entire SQL content to new server.
I had same scenario of moving 8 databases from a SQL 7 server to a newly built SQL 7 server some time ago. I used the article Greg Larsen provided (246133) and it worked fantastic. Two additional articles that were of help are: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b314546 http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b240872 Both above articles have links to other MS articles that […]
2003-07-08
RE: CaseSensitive Select
Thank you for the reply. Since the input data is very limited and the first character is unique, the ASCII allowed for simply checking of upper/lower case. The problem is in the DTS Execute SQL Task. It apparently does not allow the use of any native SQL functions (ASCII, Convert, etc) in conjunction with an […]
2003-07-08
RE: Image Insert
My experience is that BLOB will inflate the database excessively if the requirements are heavy. Therefore, I prefer using linking instead of embedding. It is a highly recommended approach for massive image requirements (which is the case where I work). Also, it makes it much easier for the Graphics Designer to design the image using […]
2003-07-08
RE: SQL Agent Auto-restart in a cluster
SQL Server Agent maybe fail to start after fail-over. Check SQL Server Agent log (Display error log) from EM and review machine application/system logs too.
2003-07-07
1 reads
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