Viewing 15 posts - 196 through 210 (of 484 total)
The script is at http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=588
if the server does not exist on the network then it will still take some time, as it tries to find the server.
Simon Sabin
Co-author of...
November 18, 2002 at 6:09 am
The clustered index has to exist in the same filegroup as the data, because the base of the index is the data.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 18, 2002 at 6:06 am
lambje
did the same as you, but didn't look at the example, reference is about 1/3 or the way down.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 18, 2002 at 5:47 am
Is it approved my mistake.
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=585
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 16, 2002 at 5:28 am
Well the obvious one is the hard copy of BOL
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 16, 2002 at 5:22 am
If you could send me a schema creation script, it would make it easier.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 16, 2002 at 5:22 am
it depends on your subquery, if you use a derived view then it will probably evaluate the whole or the derived view, but if you use a subquery in the...
November 16, 2002 at 5:18 am
Just a thought is sp_add_log_file_recover_suspect_db used when the log file has to grow?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 16, 2002 at 5:10 am
It is probably easier to generate the guid in the sql and return it
i.e
declare @GUID uniqueidentifier
set @GUID = newid
insert into mytable (...) values (@guid)
November 15, 2002 at 6:17 pm
Look at my script that scripts an SP, not yet approved but is on a post
You will have to replace insert the encryption clause in the first variable. And run...
November 15, 2002 at 6:13 pm
Its just what they are asociated with. Mine ask me what to oprn with.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 15, 2002 at 6:08 pm
Don't believe there is one just posted on web sites like this.
http://www.umachandar.com/resources.htm
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 15, 2002 at 6:07 pm
Nice! Will look at it over the weekend, if beer doesn't get in the way
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 15, 2002 at 5:46 pm
If you need to capture adhoc sql i.e. not sps then profiler is your only option. I am not sure if luminent log explorer captures that info
Simon Sabin
Co-author of SQL...
November 15, 2002 at 4:51 pm
I believe TOP is a short cirsuit function i.e once the criteria is satisfied it finishes. This is why TOP is better than SET ROWCOUNT.
Simon Sabin
Co-author of SQL Server 2000...
November 15, 2002 at 4:49 pm
Viewing 15 posts - 196 through 210 (of 484 total)