quote: It said that the first 8 lines are used for determining whether the column will be imported as char or float. This feature is not a bug, it is by design. True, but once it has decided it will only accept numbers in numeric columns and alpha in char columns, anything else will result […]
2003-12-12
1 reads
I guess the easiest way to move objects to a different filegroup would be to use Enterprise Manager. Look at BOL for filegroups -> switching filegroup for table Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-12
1 reads
NO, it's actually being started under the domain Administrator's login.
2003-12-11
2 reads
Yes that should work. But you must be sure no transactions where made in the middle because they won't be replicated. Due to a bug in SQL 2000, sometimes you can get an error if you add subscribers with out applying the snapshot. Don't remember it exactly, what it was something like couldn't insert duplicate […]
2003-12-10
1 reads
Here is your first question and my reply http://qa.sqlservercentral.com/forum/link.asp?TOPIC_ID=18953 Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-09
There are plenty of scripts out there that find duplicate indexes, but they all seem to use cursors. I didn't want to use a cursor so I ended up creating a few that could handle the duplicates and decided to share this one. This will return the table name and the names of the two […]
2003-12-04
2,712 reads
When I click on the Query Analyzer, nothing happens. I am new to SQL server 7 and would like to move the databases off one drive to another. I wanted to move the user databases from one drive to another using the detach and attach procedures via Query Analyzer. Is there an alternative method ? […]
2003-12-03
Yes, I know, it might sound nit-picking Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-02
1 reads
Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.
2003-12-02
12,249 reads
Chris Kempster brings us a basic look at the database design topic of denormalization.
2003-12-01
17,582 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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