Viewing 15 posts - 3,301 through 3,315 (of 9,715 total)
jsimancas (12/5/2013)
SELECT[PlagiarizedArticle] AS oversite
,rank() OVER (partition by [Ben-Gan].public.Apology)
FROM SQLServerCentral
Result:
||Hope all is forgiven...here's your free book by author.||
HA! I like this one.
December 5, 2013 at 6:22 am
j.zinn (12/5/2013)
December 5, 2013 at 6:20 am
One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement. Microsoft gives a certain...
December 5, 2013 at 5:09 am
Having used Litespeed before I know it wouldn't help with this backup because it's a native SQL backup.
November 1, 2013 at 6:57 am
MyPath is a SAN drive on another server. I'd love to copy the backup file over to the server that I'm going to be restoring to, but I don't have...
October 31, 2013 at 10:44 am
In that case, I'd make sure you have enough RAM for both instances to be up (when the other server fails) and still be able to run the OS, etc....
October 31, 2013 at 7:53 am
I don't advise using the same server for a warm standby of your primary database. If you lose the server, you lose both the primary and the stand by.
October 31, 2013 at 5:01 am
According to Brent Ozar's blog (in the comments) it's 64GB per instance. But you should read his reply to that comment.
http://www.brentozar.com/archive/2010/06/sql-server-r-standard-supports-less-memory/%5B/url%5D
EDIT: You should also consider what will happen to the...
October 31, 2013 at 4:50 am
Speaking of maps and geospatial data, which is a better type of data to use? Raster or Vector?
October 24, 2013 at 5:09 am
The entire structure depends on your data, what you're keeping, etc.
The way we have ours designed is by using versioning. We keep a "main" table that is narrow and contains...
October 16, 2013 at 9:34 am
SQLMaister (10/15/2013)
Select count(*) is the most efficient and correct way.
Careful there. Absolute statements like this can get you into trouble in the DBA world.
The "correct way" depends on what you...
October 16, 2013 at 4:47 am
Charles Kincaid (10/15/2013)
Brandie Tarvin (10/15/2013)
October 16, 2013 at 4:45 am
Mighty (10/15/2013)
paul s-306273 (10/15/2013)
Who'd have thought count(*) would generate so much debate...
I agree, and that apparently nobody uses a where clause while counting, but that they only are interested in...
October 15, 2013 at 8:37 am
Interesting results on the execution plan. All plans but the COUNT() on Name came backup with only an expected 9B in the row size. The Name count came back much...
October 15, 2013 at 7:30 am
The best way I've found for using COUNT(MyCol) is to use either the identity column or the primary key column. That way there are no NULL results to worry about.
SELECT...
October 15, 2013 at 6:37 am
Viewing 15 posts - 3,301 through 3,315 (of 9,715 total)