Viewing 15 posts - 20,431 through 20,445 (of 49,552 total)
Divine Flame (2/9/2012)
That depends on the environment like what else you are running on the same OS except SQL Server (like IIS ?).
No, it does not.
The 2GB/2GB division is VAS...
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
February 9, 2012 at 8:10 am
kiran.rajenimbalkar (2/9/2012)
Just please tell me which HINT's i need to use in the mentioned above SQL for retrieving the data fast.
SQl doesn't have a 'run faster' hint, and without what...
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
February 9, 2012 at 3:31 am
Dan-Ketil Jakobsen (2/9/2012)
Unfortunately the log file is full again.Stopping all jobs again. 🙁
Then you need to either move your log to a larger drive (or expand the drive) or fix...
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
February 9, 2012 at 3:26 am
vikass1 (2/9/2012)
moving clustered index to a new filegroup after droping and recreating, implicitely change the non-clustered index references.
There's nothing that needs changing in the nonclustered index if the cluster 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
February 9, 2012 at 3:25 am
sandy_1006 (2/9/2012)
How can i write a simple transaction and then roll back the transaction.
For example:i create a table and then insert few records.
CREATE TABLE dbo.t3(a int) ; and then...
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
February 9, 2012 at 2:58 am
Dan-Ketil Jakobsen (2/9/2012)
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
February 9, 2012 at 2:55 am
That's all in Books Online (though you'll need to look in 2 places - changes in SQL 2005 and changes in sql 2008).
Have you run the upgrade advisor? Have you...
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
February 9, 2012 at 2:19 am
They wouldn't. Is that second entry perhaps a non-partition aligned nonclustered index (you can't have a nonclustered index on a single partition and a partition-aligned one would have the same...
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
February 9, 2012 at 2:11 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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
February 9, 2012 at 2:07 am
Dayal Bangalore (2/9/2012)
This error is due to the non-existing file path for .mdf and .ldf files while restoring the database using .bak file.
No, it is not. It's error 5, that...
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
February 9, 2012 at 2:06 am
raj k (2/8/2012)
Great article.Does a successful backup of database imply no corruptions in the Database?
Not at all.
If you're doing a normal backup (without checksum), then nothing is checked by...
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
February 9, 2012 at 1:54 am
Check the file permissions in NTFS. Your windows account likely does not have permission to see them (and browsing via SSMS does not use the SQL Server account, it's using...
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
February 9, 2012 at 1:52 am
32 bit SQL on 32 bit OS is limited to 2GB of memory. Some (around 300 MB) is reserved (called mem_to_leave), the remainder is exactly that 1.6GB that you see.
Solutions:
Upgrade...
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
February 9, 2012 at 1:50 am
Link does not work
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
February 9, 2012 at 1:36 am
What do you mean by 'no results'?
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
February 9, 2012 at 1:36 am
Viewing 15 posts - 20,431 through 20,445 (of 49,552 total)