Viewing 15 posts - 4,156 through 4,170 (of 8,416 total)
amit.jaura 81056 (4/6/2010)
So how can I create scripts without Go using sql management studio
Tools -> Options
SQL Server Object Explorer -> Scripting
"Delimit individual statements" ... set this to 'False'
April 6, 2010 at 7:16 am
Please do read Jeff's article on Triangular Joins so you understand what an important concept it is.
It will also help you to understand why the code I posted does not...
April 6, 2010 at 7:11 am
bndgyawali (4/6/2010)
I want to run the update statement. And if the update statement is successful, then I want to run another set of statements.
So, does execute(update_statement) returns anything like...
April 6, 2010 at 6:54 am
Thiyagu-343189 (4/6/2010)
HiIs it Possible to restore SQL 2005 Master Database into SQL 2008 Master Database.If yes please let me know how to do that.
Thanks in advance
AFAIK the only supported way...
April 6, 2010 at 6:51 am
TheSQLGuru (4/6/2010)
Check for IO usage and stalls (see sys.dm_io_virtual_file_stats in BOL).
Not available in SQL Server 2000.
SSC article: http://www.sqlservercentral.com/articles/Administration/filestatsexample/862/
Also:
Bob Dorr's definitive work: SQL Server 2000 I/O Basics - highly recommended...
April 6, 2010 at 6:43 am
TheSQLGuru (4/6/2010)
April 6, 2010 at 6:36 am
Jeff Moden (4/6/2010)
Heh... on the subject of converting cursors to while loops, we do. It's a waste of time even if the cursor isn't necessarily optimal. 😉
In general, I...
April 6, 2010 at 6:25 am
Marts (4/6/2010)
I can check with my IT guy to see if something can be arranged. Does the tempdb storage need to be quick, or just seperated from other stuff?
In general,...
April 6, 2010 at 6:17 am
Mani-584606 (4/5/2010)
...process running at the time shows as Idle & which is taking all of CPU.
The 'Idle' process is just used to count unused CPU.
There is no real process called...
April 6, 2010 at 5:54 am
One last question - does the server have no direct-attach storage that you could use for tempdb?
April 6, 2010 at 5:49 am
vaibhav.tiwari (4/6/2010)
...but for some procedure its showing invalid character length and i observed that there is not purpose line in that i need to return null value for that
Yes, the...
April 6, 2010 at 5:48 am
Marts (4/6/2010)
...the server has 8 physical disks and a hardware based raid controller with 2 channels.
Thanks for clarifying - much better than software RAID, then 🙂
Currently I have one system...
April 6, 2010 at 5:41 am
USE tempdb;
GO
IF OBJECT_ID(N'dbo.Archive_PatchWSUSDetail', N'P')
IS NOT NULL
DROP PROCEDURE dbo.Archive_PatchWSUSDetail;
IF OBJECT_ID(N'dbo.ExtractString', N'IF')
IS NOT NULL
...
April 6, 2010 at 5:31 am
Viewing 15 posts - 4,156 through 4,170 (of 8,416 total)