Viewing 15 posts - 1,141 through 1,155 (of 1,199 total)
The thread is confusing. Are you looking for disk space or RAM?
xp_fixeddrives indeed gives you the available amount of free disk space (not the total space).
If you want to know...
July 12, 2013 at 2:26 am
I played with this and I was able to reproduce the behaviour. And in my test, the answer is clearly: populating the non-clustered indexes.
I had this script:
CREATE TABLE "Orders" (
...
July 12, 2013 at 2:13 am
See here for tips on how writing OPENQUERY with dynamic SQL and still stay sane: http://www.sommarskog.se/dynamic_sql.html#OPENQUERY
July 11, 2013 at 4:23 pm
All tables should have an index of the simple reason that all tables should have a primary key. (With one possible exception: tables that should only have a single row,...
July 11, 2013 at 4:19 pm
So your query windows runs either an INSERT command or a DELETE command? Else my answer would be that it's running the DELETE command once the INSERT is done.
But if...
July 11, 2013 at 4:15 pm
Do you want to add a nullable column or a non-nullable column with a default value? And where you do want to add it? As the last column?
What does "SELECT...
July 11, 2013 at 4:09 pm
Didn't you say that you had also tried BCP? I'd rather work with BCP than writing a .Net program. So if you have the BCP command (and any format file...
July 11, 2013 at 4:04 pm
It would be interesting to try to repro this. Can you share the table and index definition? I would have use for the data file as well, but I understand...
July 11, 2013 at 2:47 pm
There is a Service Pack2 out for SQL 2008 R2 out. I don't know whether that will resolve the issue, but you should be on the latest service pack anyway.
Disabling...
July 11, 2013 at 10:06 am
I echo Gail. From my experience of answering questions in forums, my gut feeling is that there is something you are not telling us. With access to the environment we...
July 11, 2013 at 10:02 am
OK. I suspect that this not the best site to ask this question. After all, it does not matter whether you have SQL Server, Oracle or something else running on...
July 11, 2013 at 9:59 am
Run the job as a CmdExec job that runs sqlcmd that directs the output to the desired file. Include SET NOCOUNT ON to get rid of "1 rows affected".
July 11, 2013 at 2:51 am
So you are physically moving all the machines, not moving SQL Server instances from one machine to another? Assuming that SQL Server databases are on a SAN, are you moving...
July 11, 2013 at 2:46 am
Does this happen repeatedly? That is, if you scratch the table and start over, does it happen again?
I found http://blogs.msdn.com/b/sqlserverfaq/archive/2009/11/04/s.aspx although that article is not entirely easy to understand. But...
July 11, 2013 at 2:43 am
As long as you don't have more then four fields, you can use parsename, although this function is specifically intended to parse object names in SQL Server and only accepts...
July 11, 2013 at 2:32 am
Viewing 15 posts - 1,141 through 1,155 (of 1,199 total)