Viewing 15 posts - 2,191 through 2,205 (of 7,502 total)
Libor Polansky (3/27/2011)
With one table where is just one record.
create table test (test int);
go
insert test select 1;
My question is:
How to completely clear buffer pool (same state...
March 28, 2011 at 12:34 am
Jeff Moden (3/27/2011)
ALZDBA (3/27/2011)
I didn't say it doesn't use model db, I said it doesn't just use model.Which is not the same as "it just doesn't use model".
Ah... my bad....
March 28, 2011 at 12:30 am
Jeff Moden (3/27/2011)
ALZDBA (3/27/2011)
Tempdb doesn't just use model.:w00t:
Ummmm.... not quite right. From the first sentence you find when you lookup "Model Database" in BOL...
The model database is used...
March 27, 2011 at 2:55 pm
What's the size of your database ?
What's the data size in your database ?
March 27, 2011 at 2:40 pm
What data size are your databases and what size is your load on a daily basis ?
Maybe work out a scenario where you take full backups of a couple of...
March 27, 2011 at 10:31 am
your whole object already resides in memory, so no physical reads needed.
March 27, 2011 at 10:25 am
Tempdb doesn't just use model.
have a look at:
select *
from sys.master_files
where database_id = 2
:w00t:
March 27, 2011 at 3:22 am
I haven't had the need to revert to sp2, but at this time I would investigate if the issues your team experiences are addressed in SP4 ( or the available...
March 27, 2011 at 3:06 am
Chances are your log file cannot be extended within the timeout sqlserver waits for the os to complete the task.
SQL will then raise the error file full, but the os...
March 27, 2011 at 3:03 am
it is a good practice to pre-size your database files.
With ssms you can expand your file(s) using the object browser, right click on the database name, click properties, click...
March 27, 2011 at 2:59 am
That is great news.
This may get me in SSCs March Madness hall of fame :w00t::hehe:
March 27, 2011 at 2:45 am
Keep in mind when updating statistics, don't include the statistics of the indexes you've just rebuilt !
An index rebuild does a 100% scan and stats update for this index. (...
March 24, 2011 at 2:17 pm
I'm sorry, this thread lost my attention ... or how should I put it 😉
Did you try:
UPDATE T
SET A_ID = A.ID...
March 23, 2011 at 12:51 am
probably your sqlserver service account doesn't have auth to your source and/or target folder.
IMO it is better to use a sqlagent for this purpose because you can easily define a...
March 22, 2011 at 2:12 pm
how about
;
;
with cteTbHierarchy
as ( /* Select all table without (selfreferencing) FK */
...
March 22, 2011 at 7:18 am
Viewing 15 posts - 2,191 through 2,205 (of 7,502 total)