Viewing 15 posts - 9,331 through 9,345 (of 49,571 total)
Regional settings on the server are probably different.
Datetime and smalldatetime don't have intrinsic formats. They're stored kinda as floating point values.
April 11, 2014 at 10:09 am
Why are you even running fibre mode? It's not a generally recommended setting, very advanced, It disabled or breaks so many other things.
April 11, 2014 at 9:55 am
charipg (4/11/2014)
actually we need to resolve the issue without reconfigure the replication .
Did you try the steps that the documentation stated?
Step 2: Execute sp_restoredbreplication (Transact-SQL). If this stored procedure...
April 11, 2014 at 4:55 am
What didn't work out? What did the referenced Books Online page say?
April 11, 2014 at 4:20 am
charipg (4/11/2014)
See the topic MSSQL_ENG003165 in SQL Server Books Online.
What did Books online say on the referenced page?
April 11, 2014 at 4:05 am
What do you mean "Everything under that gets rejected"? What is the exact behaviour you're seeing? What errors are you getting?
April 11, 2014 at 2:27 am
Huh???
If you need Table A, you access table A. If you need table E, then access table E. Why would you ever access tables B, C and D if all...
April 11, 2014 at 2:26 am
Cody K (4/10/2014)
How does it get coordinated over a group of programmers?
You put it in the coding standard, along with all your other good, required coding practices and require people...
April 11, 2014 at 1:30 am
Not actually a big mistake.
In the where clause, the Daily_car_detail table is joined to the deleted table, but the inserted table isn't joined, so you get a cross join with...
April 10, 2014 at 3:33 pm
First thing: Views are not a performance tuning technique. This is because SQL in-lines the views during parsing phase and so by the time the optimiser gets the query, there's...
April 10, 2014 at 1:50 pm
a4apple (4/10/2014)
April 10, 2014 at 12:56 pm
I will also suggest, if you've never written an article for publication before, ask someone to look over it before you submit it. Take that person's comments and review/rewrite as...
April 10, 2014 at 12:52 pm
praneethydba (4/10/2014)
and he reduced the memory CAP to 10 GB, and no issues till now....
Why? Why would you want more than half of the memory on the server to...
April 10, 2014 at 12:12 pm
It depends. It's definitely not something I'd set everywhere. It doesn't look at the time queries take, it looks at their cost and that's an estimate. It doesn't stop a...
April 10, 2014 at 11:48 am
Viewing 15 posts - 9,331 through 9,345 (of 49,571 total)