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.
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...
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...
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...
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...
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...
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...
August 18, 2013 at 2:56 am
Jeff Moden (8/17/2013)
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...
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.
August 17, 2013 at 4:17 pm
According to http://technet.microsoft.com/en-us/library/hh510202.aspx you install LocalDB with SqlLocalDB.msi.
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...
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....
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
...
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...
August 17, 2013 at 6:44 am
Viewing 15 posts - 826 through 840 (of 1,219 total)