Viewing 15 posts - 496 through 510 (of 1,583 total)
bubby (2/13/2014)
Database size = 38 GB
It is simple database
When I run the table size the biggest table is 81 Mb. total of tables is not even 1...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 8:28 pm
Try this:
Open Windows Explorer
Find a .TXT file and Right-click the file
Click "Open With"
Click "Choose Default Program"
Select "Notepad" and place a check in the "Always use the selected program to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 8:19 pm
Not sure if this helps but I did find a link that might offer you a direction to go in:
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/validate-a-url-from-sql-server.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 1:20 pm
I know this is a mute point, but I personally wouldn't go looking for performance problems for a slow running web page without first being told what is being called...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 10:18 am
I don't believe this is possible due to "scope" (as someone already pointed out). Your variable @dbstatus isn't in scope when the sp_executesql is executed therefore cannot be assigned...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 10:09 am
Sort by duration/logical reads - right-click to view the execution plan
(and the script you ran prior, you need to run that on the database in question)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 8:58 am
My mistake, Add N in front of the @dbstatus nvarchar(500) output - like so (you will need to rmeove the spaces in "d eclare"):d eclare @var nvarchar(max) = '@var1',
@sql nvarchar(max)
declare...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 8:15 am
Two questions: 1) Are you getting an error? 2) Did you restart the Reporting Service after making the change?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 7:50 am
Change your D-ECLARE @dbstatus varchar(500) and @dbstatus varchar(500) output to nvarchar(500)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 7:34 am
I believe this is related to this post (same question)
http://www.sqlservercentral.com/Forums/Topic1541179-391-1.aspx
In this case, you need to find the problematic query and review its execution plan - can you pinpoint which query...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 7:31 am
Not quite sure if i am reading your question properly but...you would see the difference in read/writes because 1) the table the non-clustered index was created on is being written...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 7:29 am
What exactly are you asking for help with?
Does the page contain a call to a database? If so, what is it calling? A procedure, a SELECT statement, etc? ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 13, 2014 at 7:21 am
Thanks Keith - this answers my question: "Note This trace flag is not required for customers who use Enterprise 64-bit editions or Developer 64-bit editions of SQL Server. Enabling this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 10:14 am
Gail, apologies in advance for hijacking the thread but can you confirm something for me? In that chapter (4) the Lock Pages in Memory states:
Initially, in SQL Server...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 9:59 am
Nice alternative Eugene, I like it!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 8:52 am
Viewing 15 posts - 496 through 510 (of 1,583 total)