Viewing 15 posts - 256 through 270 (of 459 total)
ACinKC (9/1/2011)
September 1, 2011 at 12:04 pm
karen.blake (8/31/2011)
I went with rmechaber in the end as I haven't played with cte's before and this looked challenging!
Unfortunately, my...
August 31, 2011 at 6:45 am
jpSQLDude (8/29/2011)
Tape? You guys are funny!But seriously, most places I've worked do NOT take backups seriously.
Yes, tape. Dedicated server, dedicated backup SAN, automated tape library.
Plus we have off-site...
August 30, 2011 at 7:35 am
I'm going to add to what Jason posted for you to use, with a couple of enhancements:
--Perform grouping in the CTE on the minimum # of columns needed to actually...
August 29, 2011 at 2:13 pm
aaron.reese (8/22/2011)
There should not be any conversion between data types (except possibly varchar to nvarchar - would that cause an issue?)Obiron
http://www.codersrevolution.com/index.cfm/2009/2/13/SQL-Server-Gotcha-Implicit-Unicode-Conversion
August 22, 2011 at 8:05 am
Feh, answered the question that arrived in my email this morning, which unfortunately wasn't the (corrected) question posted on the website at the time I answered.
Real lesson learned today from...
August 15, 2011 at 10:45 am
Mehernosh (8/10/2011)
I have checked the query on my sQL server 2005 enterprise box having SP4 and it appears to be displaying just right. No problems...
August 10, 2011 at 8:27 pm
Mehernosh (8/9/2011)
You might not see the results of the PERCENT_COMPLETE column if you are using:
DBCC CHECKDB WITH ESTIMATEONLY
I have checked the SQL...
August 9, 2011 at 1:53 pm
Table variables and CTEs are stored in memory (if sufficient memory is available), while temporary tables are always stored on disk.
This is untrue, or at best misleading. From http://support.microsoft.com/kb/305977:
Q4:...
August 9, 2011 at 6:57 am
Two thoughts from a probable newb about this (you've been warned):
1) w3wp.exe is an IIS process. Why would you be running IIS on a SQL server? Security and...
August 5, 2011 at 7:26 am
I tried your script and it doesn't really work for DBCC (not for DBCC CHECKDB anyway): it reports 0% PERCENT_COMPLETE for the entire duration of the execution of DBCC. ...
August 5, 2011 at 6:45 am
Excellent, glad I could help.
Read everything you can of Itzik Ben-Gan's, you will learn much!
Rich
August 4, 2011 at 3:18 pm
Calculating medians in SQL server isn't straightforward.
If you can do the work in T-SQL and just pass the result to RS, this link will help you:
http://www.sqlmag.com/article/tsql3/calculating-the-median-gets-simpler-in-sql-server-2005
Here's code I created based...
August 4, 2011 at 1:30 pm
jasona.work (7/26/2011)
:w00t:
As for dictating to the clients where to back up to, we don't tell them where or how...
August 4, 2011 at 1:21 pm
EdA ROC (7/19/2011)
Googled and found a Tech Republic webpage that provides information about using fixed vs variable and ANSI vs Unicode. 10+ Common Questions About SQL Server Data Types.
BTW,...
August 4, 2011 at 12:58 pm
Viewing 15 posts - 256 through 270 (of 459 total)