Viewing 15 posts - 826 through 840 (of 1,219 total)
Your installation appears indeed to be broken. I would try the repair option in the Installation Center.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 12:36 pm
Jeff Moden (8/18/2013)
Even if it coud be done efficiently, I'd still like to know why someone is building a result set that contains 20 million rows.
So Curious_sqldba did mention that...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 11:27 am
Jeff Moden (8/18/2013)
You said you rebuilt some of the indexes. You might not have rebuilt enough of them to free up the necessary pages to do a straight up...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 11:26 am
polkadot (8/18/2013)
Thanks Erland.I just went to path C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL and there is no Log folder there, the way there is for my default instance.
So what folders do...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 9:49 am
It seems that the installation runs into problem because of the broken VS2008 installation. Although, there is no reason to enter an instance ID, since all you are installing is...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 9:11 am
When you have a transaction that spans servers, you have a distributed transaction. Distributed transactions are handled by Microsoft Distributed Transaction Coordinator. This service is not running by default.
In the...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 3:00 am
kapil_kk (8/17/2013)
Slight changes in Erland script as cursor was not close in that script
DEALLOCATE implies CLOSE, so CLOSE it's not needed. You need CLOSE if you intend to re-open the...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 2:56 am
Jeff Moden (8/17/2013)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 18, 2013 at 2:53 am
Syntaxwise, it simple:
INSERT mytable (...)
SELECT ...
FROM SERVER.db.dbo.tbl
What do you mean with "not able to insert"? You are just staring into the blue and...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 4:20 pm
How does the query plan look like? If there are two parallel sections, each of them could use 8 threads for a total of 16.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 4:17 pm
According to http://technet.microsoft.com/en-us/library/hh510202.aspx you install LocalDB with SqlLocalDB.msi.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 4:15 pm
p.swathi4 (8/17/2013)
Tempdb has 30GB drive and it ran out of space.So i had to shrink the tempdb database.
Then you need to find another drive to extend it on.
30 GB is...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 4:10 pm
sdennis (8/17/2013)
There is still space in tempdb drive.Out of 209Gb , 130Gb is still available.
...
sp_helpdb results:
namefileidfilenamefilegroupsizemaxsizegrowthusage
tempdev1N:\tempdb.mdfPRIMARY146265152 KBUnlimited10%data only
templog2N:\templog.ldfNULL3241152 KBUnlimited10%log only
The numbers does not match up. 146 + 32 = 178....
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 12:02 pm
DECLARE cur CURSOR STATIC LOCAL FOR
SELECT FileName FROM tbl
OPEN cur
WHILE 1 = 1
BEGIN
FETCH cur INTO @filename
IF @@fetch_status <> 0
...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 6:47 am
K Currie (8/16/2013)
Ah, that worked. Not sure how it remained in sysobjects but it is gone now.
It remained in sysobjects, because it existed!
Beware that sysobjects is a compatibility view, and...
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
August 17, 2013 at 6:44 am
Viewing 15 posts - 826 through 840 (of 1,219 total)