Viewing 15 posts - 16,066 through 16,080 (of 19,564 total)
Lynn Pettis (3/22/2010)
March 23, 2010 at 12:59 am
Paul White NZ (3/22/2010)
My experience of interviewing is that candidates with certifications lack practical knowledge. Just an observation.
In many cases that is correct. However, it seems that the...
March 22, 2010 at 7:11 pm
I tend to agree with Jeff. To become proficient at TSQL, practice a lot. Try some complex requirement and find a solution for it.
March 22, 2010 at 6:15 pm
If the changes have truly made it perform that much better, I recommend you make those suggestions directly to Microsoft on their Connect site. If they deem the changes...
March 22, 2010 at 6:13 pm
amandix (3/22/2010)
March 22, 2010 at 6:11 pm
I think you are creating more work for yourself and will make maintenance on the database a little more difficult.
http://www.developer.com/db/article.php/3622881/Basics-of-Statistics-in-SQL-Server-2005
That link discusses some of the workings of statistics. Statistics...
March 22, 2010 at 6:09 pm
amandix (3/22/2010)
March 22, 2010 at 5:45 pm
Since you have added logging to it, that is good.
Does the stored procedure run in a transaction?
Maybe encapsulate the statements in the proc within a try...catch block and output errors...
March 22, 2010 at 5:35 pm
Jeff Moden (3/22/2010)
Gianluca Sartori (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
A consulting company here installed a SQL clustered Server with two nodes...
March 22, 2010 at 5:21 pm
amandix (3/22/2010)
Here follows step by step (SQL 2005 solution):
1. Copy the mdf and ldf of mssqsystemresource and rename both with copy in the end “mssqsystemresource_copy.mdf” and “mssqsystemresource_copy.ldf”
2. Attach this...
March 22, 2010 at 5:19 pm
The datasource is Oracle. The reportserver is obviously MS SQL. Which (source db or report db) is showing the contention/ blocking?
March 22, 2010 at 5:16 pm
The Dixie Flatline (3/22/2010)
I distinctly remember some of the odd things...
March 22, 2010 at 5:15 pm
In follow up to Waynes post, please document the Cluster Names, Node Names, Group names and let us know what they are (so proper advice can be given).
Also, it would...
March 22, 2010 at 3:54 pm
Silaphet Mounkhaty (3/22/2010)
I have two flat files that we process nightly say file1.txt and file2.txt. We process file1 at 12:45am and file2 at 4:45am nightly. The size of file1...
March 22, 2010 at 3:50 pm
Viewing 15 posts - 16,066 through 16,080 (of 19,564 total)