Viewing 15 posts - 1,876 through 1,890 (of 7,504 total)
can you relate your case with this SP1 fix ?
649391 DBCC corruption errors occur during SQL Server 2008 R2 collations when strings that have Jamo sequences that follow the Japanese...
July 14, 2011 at 9:52 am
check your maintenance plan log output (and sqlserver errorlog)
July 14, 2011 at 8:13 am
it states:
The owner (WIN-69WL56MFLQH\Administrator) of job Integrity Checks.Subplan_1 does not have server access.
Change the job owner to SA !
( this would be the only case one uses sa with sqlserver...
July 14, 2011 at 6:55 am
Jim Murphy (7/14/2011)
Koen Verbeeck (7/14/2011)
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*...
July 14, 2011 at 2:23 am
just to add to the replies ...
1) of course. Your operator is ">=" !
You should alter it with a ">=" and "<" ( between can have issues...
July 14, 2011 at 1:21 am
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
Viewing 15 posts - 1,876 through 1,890 (of 7,504 total)