I have a server where there is heavy file fragmentation but it is quite busy and cannot be down for long periods of time. Is there any way other than shutting down SQL Server that would allow me to run a defrag on the datafiles while the the database files are in use?
2004-05-11
How could I copy several tables from one owner to other in the same database ????? I have a database with around 150 tables with constraints checking several relationships, indexes, etc. (but without store procedures) I want to copy all of them to other owner (that I already have), in this case the destination owner […]
2004-05-11
1 reads
Make sure you set the user's default database to be a database OTHER THAN Master. That way, Master will not show in Query Analyzer unless explicitly chosen.
2004-04-22
Tried searching for a script for the best way to update isnullable and default values for all columns of a given data type but couldn't find one. I have some decimal and money fields that currently allow nulls and do not specify a default value. I would like script the altering of all of these fields to not […]
2004-04-20
1 reads
- use decimal[(p[, s])] check BOL in stead of float.- check constaints can help to delimit values : from BOL : ALTER TABLE doc_exd ADD CONSTRAINT exd_check CHECK (column_a between -99 and +99) alter table dox_exd ADD CONSTRAINT exd_check_precision CHECK (case column_a - cast(column_a as integer) when 0 then 1 when 0.5 […]
2004-04-20
This proves how ambigous these dateformats with delimiters are, and how easy they can be misread. And you show in your other post how easy it can be to get the wrong dates when relying on the delimited formats. When I wrote 01/02/03, I intended it to be 1st of February 2003.. or maybe 3rd […]
2004-04-20
2004-04-16
2004-04-12
1 reads
I'm a bit confused by your post. Are you saying you've passed a SQL Server exam, but have no real-world experience with the product?
2004-04-12
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-04-09
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