Viewing 15 posts - 1 through 15 (of 122 total)
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
Glad you have found a solution 🙂
Wkr,
Van Heghe Eddy
March 12, 2013 at 2:38 am
I think this is more a discussion with the stand from the world you belong to.
SQL DBA vs native code writers.
Well i belong to both worlds.
I used to write VB.Net...
March 11, 2013 at 7:41 am
Hi Old hand,
i think the OP means he need some average data for 1 particular column even while only a subset is returned in the actual report
If this is...
March 10, 2013 at 12:49 pm
Viewing 15 posts - 1 through 15 (of 122 total)