Viewing 15 posts - 1 through 15 (of 124 total)
This was removed by the editor as SPAM
June 6, 2019 at 7:29 am
This was removed by the editor as SPAM
June 6, 2019 at 7:28 am
This was removed by the editor as SPAM
June 6, 2019 at 6:43 am
Never used multi server admin (MSX) for maintenance plans,
however, did use it for managing +300 instances in several maintenance jobs.
Best way is to script a backup procedure (with dynamic location...
June 5, 2019 at 2:34 pm
Maybe this can help?
https://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/
Wkr,
Eddy
June 5, 2019 at 2:25 pm
Hello Webtechie,
I would not look for the old cardinality trace flag.
As it turns out, you mentioned that the databases are still in the SQL 2008 Compat level, which is a...
June 5, 2019 at 1:53 pm
SELECT --HAGS.group_id ,
HAGS.primary_replica ,
HAGS.primary_recovery_health ,
HAGS.primary_recovery_health_desc ,
HAGS.secondary_recovery_health ,
HAGS.secondary_recovery_health_desc ,
HAGS.synchronization_health ,
...
March 1, 2017 at 5:18 am
Hi Kerri,
In my understanding setting this option to "auto" is not the same as manually checking every cpu for the affinity.
In the auto modus you might...
February 3, 2017 at 4:21 am
Hi Patrick,
No, you still misunderstand.
the logspace free for use = 240 GB.
The index size however according the used pages is very small = 24GB
so it should perfectly fit...
October 21, 2016 at 7:56 am
Hi Patrick,
Think you might misinterpret the question.
Clustered index is the "table" data sorted following the keys.
No problem here.
Question i have is:
Why does a table needs more then 240GB (at least...
October 20, 2016 at 11:51 pm
Hi Gail,
Thanks again,
Thats an answer i can live with 🙂
and in fact could even come in handy while checking some data, as you can find the Original size and compare...
August 17, 2015 at 6:08 am
Hi Gail,
Thanks for your answer, and thats what i see happen here also but i wanted to know the reason why.
This because i can't seem to find any 'offical' document...
August 17, 2015 at 5:56 am
Hi Anam,
I know this is an old thread, but i was just recently busy with calling SQLCMD from vbscript.
Possibly this can be of some help for somebody else.
Facing the same...
December 21, 2014 at 11:19 pm
Hi MadZebra,
Just a thought,
But can't you not just create a new filegroup on another disk (new datafile) and assign the next range partition to the new filegroup.
Then set a new...
December 17, 2013 at 2:06 am
Hi,
Try this one
UPDATE bck
SET bck.ProcID = ori.ProcID
FROM dbo.BlogCopy_copy as bck inner join dbo.BlogProcedures as ori
on bck.WebID=ori.WebID
Using aliasses of tables is a good habit that you really should learn to...
March 20, 2013 at 8:00 am
Viewing 15 posts - 1 through 15 (of 124 total)