Ron McCullough

Forum Replies Created

Viewing 15 posts - 166 through 180 (of 3,220 total)

RE: Data compression

Nice question on basics ....

January 29, 2013 at 8:46 pm

#1582451
RE: CHOOSE - 1

Hugo Kornelis
I am surprised to see that you responded to one post, but didn't respond in any way to the criticism from other posts. With that, you create the appearance...

January 29, 2013 at 8:53 am

#1582185
RE: CHOOSE - 1

davoscollective
A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both the...

January 29, 2013 at 6:46 am

#1582106
RE: Help on how to count guests in hotel every day

Maple07-598122 (1/25/2013)
I have a table keeps guest records in a hotel. For each guest I have check in date and check out date. If I want to know how many...

January 25, 2013 at 3:23 pm

#1581224
RE: Create string using input values

Here is another method .... not efficient .... not recommended ... but it does what you seem to need to do.
DECLARE @BegYr INT = 2013
...

January 25, 2013 at 11:51 am

#1581173
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (1/25/2013)
Are the posted posts about the posted questions and posted answers getting posted worse-ly than previous posters posted in the posted past?
NO, NO, NO, YES...

January 25, 2013 at 10:58 am

#1581150
RE: Online training for sql 2012 ( focus on performance )

Check out any training given by Paul Randal. ... just search using google for his latest schedule, and check out his blog ... has lots of free training available from...

January 23, 2013 at 7:18 pm

#1580331
RE: Grouping Active units by YYYYMM

To assist those who can and want to help you ... please post table definition, some sample data.
To do so click on the first link in my signature block. ...

January 23, 2013 at 9:29 am

#1580170
RE: An oddball survey, seeing as I'm looking at a new car...

Lamborghini - hope your pocket book is as great as your taste in cars.
Me Mercedes (Diesel) excellent milage .. long trips at avg speed 70+ ... 39 mph using...

January 21, 2013 at 1:19 pm

#1579367
RE: EOMONTH - 1

Revenant (1/21/2013)
Ron, as always I love your question. Please keep them comin'!
Thank you .. coming from one as knowledgable as you about sql ... it is an honor

January 21, 2013 at 1:14 pm

#1579364
RE: Import data from one table to another excluding any duplicates help

Look at using the MERGE statement
http://technet.microsoft.com/en-us/library/bb510625(v=sql.100).aspx

January 21, 2013 at 10:59 am

#1579332
RE: Are the posted questions getting worse?

john.arnott (1/18/2013)
SQLRNNR (1/18/2013)
Lowell (1/18/2013)
Brandie Tarvin (1/18/2013)
All we need is an actual Go Faster flag for the database, and everything will be FINE.
got your fix right here:
I need one of those
Funny...

January 18, 2013 at 7:01 pm

#1578918
RE: SQL Server 2012 Express Management Studio does not show columns of tables in tempdb

Can you post your actual T-SQL might help us help you

January 18, 2013 at 4:54 pm

#1578908
RE: Number of Rows

Dave62 (1/18/2013)
bitbucket-25253 (1/18/2013)
...
Been there done that ... the message tab is NOT, let me repeat, the message tab in NOT part of the estimated execution plan
I think the message tab...

January 18, 2013 at 2:05 pm

#1578882
RE: Number of Rows

Dave62 (1/18/2013)
L' Eomot Inversé (1/18/2013)
...
So either I am missing something, or there's been a change in behaviour between 2008+SP3 and 2008R2+SP3.
Try this:
1) Paste code into SSMS query analyzer
2)...

January 18, 2013 at 12:11 pm

#1578842

Viewing 15 posts - 166 through 180 (of 3,220 total)