Viewing 15 posts - 1,861 through 1,875 (of 7,498 total)
- can you elaborate on what you are actually trying to accomplish ?
- why are you using xp_cmdshell ?
- why aren't you using sqlcmd or bcp ? (maybe even just...
July 18, 2011 at 10:51 am
hoanglong88i (7/18/2011)
Place_ID AllAvai Today Tomorrow
1201
2211
3000
4000
Hi Alzdba,
I'm taking time on functions DATEADD and DATEDIFF. Yes, really I also feel my...
July 18, 2011 at 6:44 am
July 18, 2011 at 4:38 am
How about this:
SELECT Place_ID
, ReceivedDate
, COUNT( case when ReceivedDate >= DATEADD(DD, DATEDIFF(dd,0, GETDATE()) ,0)
...
July 18, 2011 at 4:27 am
The log backups is a must to keep control over the log file size.
Managing Transaction Logs by Gail Shaw[/url]
and
July 17, 2011 at 6:20 am
SQLkiwi (7/16/2011)
I normally write such stubs the other way around, to avoid all that tedious messing about with quotes in the view definition:...
+1 because of the lack of 'create...
July 17, 2011 at 6:16 am
edited: Almost posted code in The Thread .:blush:
For those interested ...
Just in case anyone could use a little hand slipstreaming SP1 into his SQL2008R2 ... 😀
and SSC doesn't have a...
July 15, 2011 at 8:13 am
As already stated by Jayanth_Kurup those numbers depend on the datefirst parameter of your instance !
Doublecheck it.
Also have a look at the second query I provided, it will return the...
July 15, 2011 at 1:05 am
Mind me tossing in my all time favorit when it comes to what the log is all about and why your choice of recovery model matters ?
- Managing Transaction Logs[/url]
and
-...
July 15, 2011 at 12:43 am
Since we're at it, can you convert your scalar value function to a table value funtion.
That should give you a noticable performance gain, but requires query modifications !
July 15, 2011 at 12:36 am
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
Viewing 15 posts - 1,861 through 1,875 (of 7,498 total)