Viewing 15 posts - 22,681 through 22,695 (of 49,552 total)
Ninja's_RGR'us (10/26/2011)
GilaMonster (10/26/2011)
Ninja's_RGR'us (10/26/2011)
Worse comes to worst I can come in for a quick consult to try and figure it out for you.
Or I can do a remote perf review,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 7:56 am
Starting from the command line or editing the startup parameters in service control manager?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:37 am
jcrawf02 (10/26/2011)
missed a couple user group meetings I meant to get to (online), would...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:35 am
I just noticed, with what you said, what's wrong.
-d is followed by the location of the master data file
-l by the location of the master log
-e by the location of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:20 am
ggareth (10/27/2011)
-m F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
-e F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:08 am
Share permissions are irrelevant, they're only used by something accessing the server from the network.
Please browse to the folder and check the NTFS permissions on the folder and files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:06 am
Gianluca Sartori (10/27/2011)
Vishal.Gajjar (10/27/2011)
Adhoc queries need to be exactly same for reuse. i.e. case-sensitivity, white spaces, etc...True indeed, except for whitespaces.
Actually he's completely right. The plan cache key for ad-hoc...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 4:59 am
Gianluca Sartori (10/27/2011)
In SQL Server 2000 we did not have "plan cache", there was just "procedure cache" and it was a totally different story.
2000 did cache ad-hoc queries, it was...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 4:56 am
Parameter sniffing? Can you post the query and the plans?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 4:46 am
spidey73 (10/27/2011)
That's not what I asked about. Does the SQL Server service account have full control (in Windows) to the files and folders involved? (all of them)
The Service account has...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 4:38 am
jorge_gomes98 (10/27/2011)
"What do you mean 'mistake'?
"
Error! CRC Error!
That's not very helpful. What is the EXACT error message you get when taking a database backup?
I am now copying tables to another...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 4:32 am
Elliott Whitlow (10/26/2011)
You do have backups?
I suspect this is a interview/theoretical question (at least I hope it is)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2011 at 2:52 pm
What you're seeing is not that uncommon, especially if you have tables with data skew, where some values are present more than others.
If you need fullscan, you need fullscan. If...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2011 at 2:26 pm
Define 'crashed'
What's the situation? What's happened? What are the errors?
If you want very first thing I'd do - notify business that there is a problem, notify management that there's a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2011 at 2:03 pm
jared-709193 (10/26/2011)
"Log truncation frees space in the logical log by deleting inactive virtual log files form the start of the logical log."
Not quite correct.
Log truncation frees space in the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2011 at 1:28 pm
Viewing 15 posts - 22,681 through 22,695 (of 49,552 total)