Viewing 15 posts - 121 through 135 (of 629 total)
Nope. Unless you were tracking and logging that information there is no way to go back 3 months ago and see the execution time. In addition the DMV...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 16, 2009 at 6:46 pm
I think page faults are bit high but doesn't mean SQL Server is under memory pressure; it is your OS is complaining "a bit" or other processes running on the...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 15, 2009 at 3:19 pm
Maybe the transaction is being rolled back because of Triggers?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 15, 2009 at 2:43 am
For test Data generation RedGate Data Generator ROX! Best tool ever ;-).
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 15, 2009 at 2:39 am
Okay in that process you did not grant the login any permissions to the database. This is just creating a server login; now you have to create a database...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 14, 2009 at 10:05 pm
As George said re-install might be you only open; but from your previous screen shots some components did get installed.
When you were installing did by chance enter another folder for...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 14, 2009 at 9:04 am
I don't know how to translate that number; few times I ran into it I couldn't figure out. I got lucky that someone else had ran into exact same...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 13, 2009 at 4:37 pm
raym (4/13/2009)
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
These are correct; but please go to that path C:\Program Files\Microsoft SQL Server\MSSQL.1\ and see if said files exist in...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 13, 2009 at 4:08 pm
Hi,
No it doesn't mean there is memory pressure; the target memory value is taken from the maximum memory setting. And the server usage means that SQL...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 13, 2009 at 1:07 pm
It is an issue with quotes .. try
EXEC ('create proc BULK_INSERT_DATA ( @caminho varchar(500) )
as
set xact_abort on
set nocount on
declare @SQLStatement as varchar(500)
truncate table bulk_Contribuintesest
set @SQLStatement = ( ''BULK INSERT...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 13, 2009 at 1:00 pm
Check to confirm the SQL Install completed successfully and your setup path information for the master database is correct.
You can you use "SQL Server Configuration Manager" to see the startup...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 13, 2009 at 12:08 pm
Try using ..
RESTORE headeronly FROM DISK = 'bkfilename.bak'
This will give you the version under SoftwareVersionMajor, SoftwareVersionMinor, and SoftwareVersionBuild.
From the build you can go to http://sqlserverbuilds.blogspot.com/ to see what version you...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 13, 2009 at 10:24 am
I am sorry I haven't used Log Shipping much other then searching on Google; I couldn't provide much help. I hope someone else can point you to proper resources.
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 12, 2009 at 6:38 pm
My searching only found ...
Another note while searching I found while reading the white paper above Mirroring is not 100% automatic failover with sharepoint technolgoies because the front end in...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 12, 2009 at 1:31 pm
Please check ..
1) Firewall (Any changes that would start blocking port 1433)?
2) Remote access still enabled on TCP/IP.
3) MSSQL Server is running.
Any patching?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 11, 2009 at 4:35 pm
Viewing 15 posts - 121 through 135 (of 629 total)