Viewing 15 posts - 601 through 615 (of 1,583 total)
[Btw, unless this was a deliberate attempt to cause an issue, be-atching about it just slows you down, and may upset others; be-atch after it's cleaned up, if you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 10:06 am
Maybe something like this?WITH Data (col1, col2, col3, Docket_date) AS
(
SELECT col1, col2, col3, Docket_date FROM dbo.DocketTB ORDER BY Docket_Date DESC
UNION ALL
SELECT col1, col2, col3, Date_Raised FROM dbo.WorkshopTB ORDER...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 9:11 am
The trace option is probably a good place to start in finding your culprit (my preferred method) - although i'd probably create a custom trace in profiler say tracking only...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 8:46 am
Of course I know NOLOCK/READUNCOMMITTED is the same thing 🙂 I wasn't meaning to say that ALL locking happens in the vendors app, I was meaning to say that...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 8:09 am
I hear what you guys are saying. It's mostly trying to talk the reporting guys out of attempting to handling EVERYTHING within the SQL stored-procedure and encourage them to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 29, 2013 at 7:26 am
I think I got around it...pasted it from my iPhone!
I've set this up with the central logging table on a database server, and have all other (desired) SQL Servers...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 28, 2013 at 2:43 pm
I can't post the code from the office due to our proxy server not liking some of the keywords in the sql code, I can either email it to you...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 28, 2013 at 2:15 pm
What version of SQL are you using?
Also, check out this prior post - looks like it could be helpful
http://www.sqlservercentral.com/Forums/Topic565482-6-1.aspx#bm936680
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 28, 2013 at 2:04 pm
I've created an automated process that logs all the CREATE, DROP, ALTER events from the default trace file into a centrally stored table (basically using a stored-procedure and a SQL...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 28, 2013 at 9:10 am
Take the following example:DECLARE @String varchar(15)
SET @String = ' 012 4567 '
SELECT LEN(@String), DATALENGTH(@String)
(LEN())(DATALENGTH())
910
LEN() excludes trailing spaces, so when you use it in your WHERE clause I believe it's actually...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 27, 2013 at 7:58 pm
Wait a minute....if you have unique clustered indexes what's the issue with creating the primary keys? It would make your entire issue with replication much easier! Is there...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 27, 2013 at 3:53 pm
You can override the data source credentials on the report server. Go to the data sources and set the account you want to use, then in your BIDS project,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 27, 2013 at 3:28 pm
Snapshot replication is what you're stuck with...I've not heard of 3rd software that would handle it (then again I probably wouldn't have heard about it anyway, they don't let me...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 27, 2013 at 3:26 pm
Well that is good news, however if you post the errors the people willing to help just might be able to help you through the situation...so in the future should...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 27, 2013 at 11:38 am
As I'm sure most people would tend to agree: why would you place your system files on C:\? In the event of issues from the OS-level or the drive...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 27, 2013 at 6:31 am
Viewing 15 posts - 601 through 615 (of 1,583 total)