Viewing 15 posts - 1,876 through 1,890 (of 7,498 total)
Have a look at:
- How to: Shrink a Database (SQL Server Management Studio)
July 14, 2011 at 1:10 am
SQLBOT (7/13/2011)
...I think this means that each cluster needs a drive letter, but you can mount as many mount points on that drive as you want....
Indeed.
All luns need to be...
July 14, 2011 at 12:04 am
kapfundestanley (7/13/2011)
..failing without giving a clear error message.....
Please post all error information you can.
- Errorlog file of sqlserver
- MP log ( if you configured it)
even if it seem worthless, post...
July 13, 2011 at 8:30 am
FWIW maybe this way can also be given a try if you have a larger volume of data to process.
As shown in the script it is based on Adventureworks for...
July 13, 2011 at 6:55 am
Mark-101232 (7/13/2011)
ALZDBA (7/13/2011)
Very nice solution Mark. :smooooth:I hope OP understands the performance impact.
Yep, I suspect there's a fast way to do this without having to group by a concatenated string....
July 13, 2011 at 3:23 am
Very nice solution Mark. :smooooth:
I hope OP understands the performance impact.
July 13, 2011 at 3:10 am
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Crystal ball needed here. I forgot mine at home. 😀
I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked for!...
July 13, 2011 at 2:51 am
Define Group1, Group2 and Group3. What are the cryteria ?
Are there any other groups ?
Is your grouping dynamic ?
July 13, 2011 at 2:50 am
FWIW I just signed up to Google+ 🙂 Just to see what it's all about.
Let's see... facebook, LinkedIn, Twitter, G+, the fora .... It's gonna need a FTE...
July 12, 2011 at 1:30 am
NULL means unknown value for this column on this row.
You'll have to determine - based on your knowledge of your data system - how to interpret it for your case.
If...
July 11, 2011 at 12:32 am
We use mount points on almost all of our clusters because of that reason.
We haven't experienced issues with it over the years.
However, you need to take into account you need...
July 10, 2011 at 6:47 am
Tom.Thomson (7/8/2011)
ALZDBA (7/8/2011)
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Keep in...
July 9, 2011 at 2:23 pm
SQLkiwi (7/8/2011)
--- never mind ---
Is that a new "Knock, Knock" ?
July 9, 2011 at 2:19 pm
just to add to the previous replies...
for such kind of maintenance, I always advise to disable the services ( or take the cluster resources offline ) so they don't auto...
July 9, 2011 at 5:14 am
did you take your db offline _before_ the file copies / lun copies?
July 8, 2011 at 10:06 am
Viewing 15 posts - 1,876 through 1,890 (of 7,498 total)