Viewing 15 posts - 376 through 390 (of 3,221 total)
Thanks for an easy, back to basics question.
July 14, 2012 at 4:18 pm
Luis Cazares (7/14/2012)
You're right, I got confused with the term as I haven't used it in a long time.
Don't feel bad, I had to Google it to be reminded of...
July 14, 2012 at 2:27 pm
I do not like to be a kill joy but the MEDIAN is defined as:
median of a distribution with a discrete random variable depends on whether the number of terms...
July 14, 2012 at 2:00 pm
I suggest you visit this site, and there you may find a solution to your problem.
Or read this article on SSC
http://www.sqlservercentral.com/articles/SS2K5+-+CLR+Integration/3208/
July 14, 2012 at 10:22 am
One possible method is to use a temporary table for example:
CREATE TABLE #T(Id INT IDENTITY(1,1),Tname VARCHAR(100),NumRows INT,RowsMod INT,Rspace INT, Uspace INT, StatDate DATETIME)
INSERT INTO #T(Tname,NumRows,RowsMod,Rspace,Uspace,StatDate)
SELECT -- remainder...
July 14, 2012 at 6:10 am
Revenant (7/13/2012)
Lynn Pettis (7/13/2012)
Brandie Tarvin (7/13/2012)
YAY for people who still allow SQL Injection on their servers! (NOT!)http://news.cnet.com/8301-1009_3-57470786-83/hackers-post-450k-credentials-pilfered-from-yahoo/%5B/url%5D
Yes, saw that on twitter yesterday.
Some people will never learn I guess.
I am curious...
July 13, 2012 at 12:24 pm
Here is a link posted by Steve Jones on 12/31/2007 12:43 PM
http://www.sqlservercentral.com/Forums/Topic437598-324-1.aspx#bm437640
which in turn contains this link:
http://technet.microsoft.com/library/Cc966393
With no workload governor, there should be no limit as far as the database...
July 12, 2012 at 12:53 pm
Very easy QOD ... but then wondered, what is the gimmick, what am I not understanding ... after reading it about 10 times I concluded no tricks, nothing hidden just...
July 12, 2012 at 4:56 am
To gain another perspective, and method to "refresh/update" the views meta data may I suggest looking at an older QOD at:
http://www.sqlservercentral.com/questions/Views/88916/
What happens behind the scene, so to speak, is shown...
July 11, 2012 at 6:30 am
It appears that Level 6, Level 7, and Level 8 have yet to be published. Other than attempting to contact the author and asking i guess we just sit...
July 9, 2012 at 12:23 pm
And may I thank you for letting me know that I may have been of some benefit... too often those who are helped do not acknowledge the help given.... so...
July 9, 2012 at 9:45 am
Why do you need a case statement ? When something like this will produce the results you have indicated that you require.
CREATE TABLE #T(theStringis VARCHAR(50))
INSERT INTO...
July 9, 2012 at 9:10 am
This might be what you require.
CREATE TABLE #Address(HomeAddress VARCHAR(75))
INSERT INTO #Address
SELECT '13480 lone point lane' UNION ALL
SELECT '4420 Douglas...
July 7, 2012 at 6:25 am
Viewing 15 posts - 376 through 390 (of 3,221 total)