Viewing 15 posts - 1,561 through 1,575 (of 3,221 total)
Roy Ernest (12/23/2010)
Happy Holidays to everyone....!!! I wont log on to SSC or anything. So, Have fun everyone... See you all after Christmas.
And a happy holiday to you and yours...
December 23, 2010 at 1:47 pm
WayneS (12/22/2010)
I encourage...
December 22, 2010 at 10:12 pm
After being told that I had selected the wrong answer, I copied the code to SSMS for SQL 2005, and to SSMS SQL 2008 ....
In BOTH 2005 and 2008...
December 22, 2010 at 9:55 pm
Examine the DATFDIFF and or DATEDIFF functions
You answer seems to be incorrect 149 days ... even if each month between 08/25/2010 and some future date contained 31 days it...
December 21, 2010 at 4:00 pm
ns_18 (12/21/2010)
If ther is any duplicate data then my SQL should run and find the duplicate rows and then delete them automatically.
Do you...
December 21, 2010 at 3:29 pm
ns_18 (12/21/2010)
If ther is any duplicate data then my SQL should run and find the duplicate rows and then delete them automatically.
Do you...
December 21, 2010 at 2:31 pm
Anthony Johnson-756248 (12/21/2010)
Please provide data access controls that should be a standard to the database administration and data control areas of the community.
Your question is rather vague, however you may...
December 21, 2010 at 9:28 am
This will allow you to view specific columns by name, or by data type along with their associated table name.
SELECT so.Name AS 'Table',sc.Name AS 'Column'
FROM sys.sysobjects so...
December 20, 2010 at 5:11 pm
I realize this is a "global" community and many folks don't celebrate Christmas but here's to the folks who keep SQL Server Central alive and kicking including employees, lurkers, casual...
December 18, 2010 at 7:33 pm
Thanks for the heads up ... nice quite Saturday .... downloading was quick ... Again thanks
December 18, 2010 at 7:33 am
I do not envy your chore, but would suggest using a search of TECHNET
to find the information you require.
The link above will return some 8,780 references, amongst which I believe...
December 17, 2010 at 8:14 am
WayneS (12/16/2010)
bitbucket-25253 (12/16/2010)
WayneS (12/15/2010)
My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?
Wayne I believe it was a good question, and...
December 16, 2010 at 1:57 pm
Try reading the following articles / blog posts to determine additional methods or items to check to determine why tempdb is not shrinking.
and
http://www.sqlservercentral.com/articles/tempdb/65919/
December 16, 2010 at 1:10 pm
WayneS (12/15/2010)
My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?
Wayne I believe it was a good question, and I for...
December 16, 2010 at 11:21 am
Viewing 15 posts - 1,561 through 1,575 (of 3,221 total)