Viewing 15 posts - 226 through 240 (of 1,079 total)
Hi Gail, just by looking at the service in Task Manager it's obvious it is idle.
Any ideas?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 22, 2015 at 2:44 am
Your last reply confused me a bit but I think you meant you can't get the affected DB in offline mode?
ONLY if the above is true AND you intend to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 29, 2014 at 5:27 am
open your Windows Resource Monitor to view which process is resource intensive:
From the Run box (windows key+R), enter
C:\Windows\System32\resmon.exe
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 29, 2014 at 5:22 am
http://www.sqlservercentral.com/articles/Reporting+Services/106306/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 29, 2014 at 4:26 am
Run the following to determine who and how many connections are open against which DB's
SELECT
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 29, 2014 at 4:24 am
Just because SSMS takes long to open doesn't mean SQL is the cause.
Your CPU utilization could be caused by any other process on your server, and you'll need to...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 29, 2014 at 12:16 am
yes.
http://msdn.microsoft.com/en-us/library/ms143506.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 29, 2014 at 12:11 am
Koen Verbeeck (1/28/2014)
philosophaie (1/27/2014)
How do you write the date and time into datetime?
You mean assigning a literal value to a datetime variable?
DECLARE @datetime DATETIME;
SET @datetime = '2014-01-28T08:26:14';
SELECT @datetime;
philosophaie (1/27/2014)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 28, 2014 at 1:43 am
Make use of parameters for a start and end date, or a date as a single value, depending on your requirements.
Add a parameter as Date/Time Type, Set the Default Value...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 27, 2014 at 10:49 pm
Well, did you
consult the event log or other applicable error logs for details"
?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 29, 2013 at 11:15 pm
create procedure _sp_importexceldata
(@Source varchar(1000)
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 24, 2013 at 11:03 pm
myhost\myinstance -- does not work
Are you referring to "myhost" as the SQL Cluster Virtual Name or the local active node?
Use the SQL cluster name instead of the node name or...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 2, 2013 at 10:54 pm
Was there a question?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 10, 2013 at 11:04 pm
http://msdn.microsoft.com/en-us/library/ee730351.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 9, 2013 at 12:20 am
looks like the results from a csv/txt file?
Tried using SSIS and selecting "First column is headers", delimit it properly to assign columns?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 8, 2013 at 11:43 pm
Viewing 15 posts - 226 through 240 (of 1,079 total)