Paul White

Forum Replies Created

Viewing 15 posts - 4,531 through 4,545 (of 8,416 total)

RE: Please help me to resolve this query

anshu84onnet (3/31/2010)
thanks for getting me that point master database was selected as default at that point so not getting data now got the data thanks a lot....i need one...

March 31, 2010 at 10:03 am

#1143234
RE: to find count of rows

naresh1253 (3/31/2010)
Oh..thats a better approach. Thanks for the advice.
No worries.

March 31, 2010 at 9:59 am

#1143229
RE: Advice on an OR statement

It all boils down to the way SQL Server estimates cardinality and cost when an OR is present.
Are you using SQL Server 2008? The optimizer frequently manages this type...

March 31, 2010 at 9:59 am

#1143227
RE: SQL 2008 Compressed Backups

Yes, used in production, replacing LiteSpeed.
Very happy with it.

March 31, 2010 at 9:50 am

#1143222
RE: What is the RAM ramification of CTE?

GilaMonster (3/31/2010)
I would argue that you're inserting into a table variable through a CTE. The CTE is not the thing storing the data. The point I was trying to...

March 31, 2010 at 9:48 am

#1143219
RE: Are the posted questions getting worse?

Chris Morris-439714 (3/31/2010)
Jasey-wasey.
Awesome.
I work for a posh bra company, and on that day, I fitted in one.
Double awesome, with chocolate awesome sprinkles.

March 31, 2010 at 9:38 am

#1143209
RE: SQL 2008 standard x64 help - unable to truncate / re-create 2 log files

GilaMonster (3/31/2010)
Paul White NZ (3/31/2010)
He will still need to run EXEC sys.sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1;
If this is one...

March 31, 2010 at 9:36 am

#1143206
RE: What's the count?

timothy.g.parker (3/31/2010)
It should be noted, that depending on your record sets, the count(*) should be replaced with count_big(*) to give the you the correct results.
Ever wonder why there's no SUM_BIG?

March 31, 2010 at 9:34 am

#1143202
RE: An interesting thing about isnull

Trey Staker (3/31/2010)
Also, I learned a lot more from the discussion from Paul and Hugo.
Hey thanks, Trey. Hugo's always good for a quality discussion 🙂

March 31, 2010 at 9:32 am

#1143198
RE: What is the RAM ramification of CTE?

GilaMonster (3/31/2010)
Except that you cannot insert into a CTE.
Someone's going to post this...may as well be me 🙂
DECLARE @T
TABLE (A INTEGER NOT NULL);
WITH CTE
AS ...

March 31, 2010 at 9:30 am

#1143193
RE: SQL 2008 standard x64 help - unable to truncate / re-create 2 log files

GilaMonster (3/31/2010)
Paul White NZ (3/31/2010)
Yes (providing the database is shut down cleanly before the logs are deleted), however here it'll be a temporary fix. The log will simply grow again...

March 31, 2010 at 9:25 am

#1143180
RE: Internal architecture of SQL SERVER

Understanding Pages and Extents
Managing Extent Allocations and Free Space
Managing Space Used by Objects
Tracking Modified Extents
Transaction Log Logical Architecture
Transaction Log Physical Architecture
Checkpoints and the Active Portion of the Log
Write-Ahead Transaction Log
Nothing...

March 31, 2010 at 9:22 am

#1143176
RE: SQL 2008 standard x64 help - unable to truncate / re-create 2 log files

If all you want to do is to get rid of the logs, the fastest way is to use the CREATE DATABASE...FOR ATTACH_REBUILD_LOG statement.
sp_attach_single_file_db is limited to databases that only...

March 31, 2010 at 9:15 am

#1143169
RE: Internal architecture of SQL SERVER

Books Online (the help system that comes with SQL Server) is also an excellent resource, and may be more accessible to the beginner.

March 31, 2010 at 9:06 am

#1143160
RE: What is the RAM ramification of CTE?

keepintouch2b (3/31/2010)
"Beware, though, when many users start using table variables -- large amounts of RAM are used because all temporary tables are stored and processed directly in memory. Table variables...

March 31, 2010 at 9:02 am

#1143157

Viewing 15 posts - 4,531 through 4,545 (of 8,416 total)