Viewing 15 posts - 256 through 270 (of 1,109 total)
vblllove (4/10/2008)
April 10, 2008 at 4:58 am
Zsolt Szabo (4/10/2008)
CREATE INDEX
[INDEX01] ON [TABLE01] (Column01, Column02, Column03)
INCLUDE (Column04, Column05, Column06, Column07)
with...
April 10, 2008 at 4:56 am
karthikeyan (4/10/2008)
Again,can't we achieve this...
April 10, 2008 at 4:09 am
SQLZ (4/10/2008)
I'm pretty sure that Microsoft's "View Dependencies" functionality included in Managment Studio also parses to correctly return the dependencies - plus you can drill-down through each dependecies' dependencies. ...
April 10, 2008 at 4:06 am
On SQL Server 2000 you can look at the dbo.sysdepends table, on SQL Server 2005 the sys.sql_dependencies.
Unfortunately neither of these system tables/system views are reliable, and many times they do...
April 10, 2008 at 3:23 am
Peso (4/9/2008)
Here is how CHECKSUM is calculated and how you break it.
Very Impressive!
Have you had a look at how MS handles a list of values?
CHECKSUM seems to do different...
April 9, 2008 at 8:42 am
Jeff Moden (4/9/2008)
How can you say that? I just ran ST's code in 2k and 2k5 and, all other things being equal, they both come up with the exact...
April 9, 2008 at 8:24 am
Andras Belokosztolszki (4/9/2008)
souLTower (4/9/2008)
If I use checksum() in SQL2000 will I get the same results in 2005 and later versions.EX:
select checksum('abcdefg') -- yields -2039903324
Thanks
ST
No, you will not.
Regards,
...
April 9, 2008 at 6:42 am
souLTower (4/9/2008)
If I use checksum() in SQL2000 will I get the same results in 2005 and later versions.EX:
select checksum('abcdefg') -- yields -2039903324
Thanks
ST
No, you will not.
the above statement...
April 9, 2008 at 6:37 am
Bilichi (4/9/2008)
Is it possible to reduce the Log file size?if possible please provide...
April 9, 2008 at 3:58 am
Bilichi (4/9/2008)
May i know what is the use of dump tran command in database?
It backs up your transaction log.
More info is in books online under "BACKUP LOG" http://msdn2.microsoft.com/en-us/library/ms186865.aspx
Regards,
Andras
April 9, 2008 at 3:38 am
Bilichi (4/9/2008)
HiHow to clear the log file without detaching the database?
Is there any command to do it?
Why do you want to do this? Has it grown too much?...
April 9, 2008 at 3:23 am
windows_mss (4/9/2008)
I'm planing to launch an site, In which I'm going to Use SQL Server 2000,
I'n future there may be Million of Users. So now how should I Design...
April 9, 2008 at 3:19 am
You could use osql as well as Management Studio (a graphical fronted, which if you do not have installed can install for SQL Server Express from http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en)
Regards,
Andras
April 9, 2008 at 1:59 am
nithyapoy (4/8/2008)
Thanks.But Is it possible without creating Temporary Table.
You do not need the temporary table (or table variable) at all. Just take the select part of Absinthe's example, and use...
April 9, 2008 at 1:55 am
Viewing 15 posts - 256 through 270 (of 1,109 total)