I don't like bit values because I can never remember what the values stand for (or is it I can never remember what the values stand for because I never use bit values?). Anyway, I've seen too many examples where there is no consistency with bit values - sometimes it is Yes/No other times it […]
2003-11-25
Not much other than failure error as shown below. I won't be back in my office til Monday so I'm not being rude by not replying... I really do appreciated your help on this. 2003-11-20 12:30:08.15 backup Database differential changes backed up: Database: TCPrd, creation date(time): 2003/06/24(07:38:28), pages dumped: 14395, first LSN: 16318:876:5, last LSN: […]
2003-11-20
1 reads
What is in the error log after you get the 3201 error? --Jonathan
2003-11-20
1 reads
Its a good question and another one I dont know the answer to. I guess the thing to do is formulate a plan for proving the results? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-20
2 reads
sysmessages only contains the generic error message, without references to the particular objects. For example: Unclosed quote before the character string %.*ls. Is that specific enough?
2003-11-14
2003-11-14
GeraldH, before you start to do any recovery, i suggest that we (everyone who is on-line and readind this post) together make a plan first, a clean steps, test on other server(s). xyz.
2003-11-13
just get rid of the time part on the input and sample dates. Method1 casting as int Cast(@inputDate1 as int) Method2 remove time part @newinputdate = Cast(Convert(varchar(10),@inputDate, 101) as datetime) Method3 you could use acombination of DateDiff using 'd' as the difference HTH
2003-11-13
1 reads
Someone's created a table called "c:\temp\sales.txt". It's just an object in your database with an operating-system-like name. It can be done like: create table [c:\temp\sales.txt] ( x int) Cheers, - Mark
2003-11-13
1 reads
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
2008-05-09 (first published: 2003-11-10)
66,278 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers