Viewing 15 posts - 10,786 through 10,800 (of 49,566 total)
ben.brugman (11/29/2013)
I did understand that the datetime in SQL-server is stored as the number of microseconds / 3 since 1899-12-30.
No. Never has been.
Datetime is made up of two pieces. The...
November 29, 2013 at 5:54 am
Pretty much, just use different backup file names. Otherwise you're liable to make some mistake somewhere.
db_full.bak and db_diff.bak for example.
November 29, 2013 at 5:39 am
kapil_kk (11/29/2013)
GilaMonster (11/29/2013)
INSERT INTO TableB ...SELECT ...
FROM TableA
WHERE NOT EXISTS (SELECT 1 FROM TableB where <column comparison>)
Sorry to mention that I also have update the record if data from tableA...
November 29, 2013 at 3:32 am
INSERT INTO TableB ...
SELECT ...
FROM TableA
WHERE NOT EXISTS (SELECT 1 FROM TableB where <column comparison>)
November 29, 2013 at 3:22 am
No. It's a property of the client tool only, not something that SQL Server sets within itself
November 29, 2013 at 2:18 am
If the developers have enough rights to run that, they have enough rights to just log directly on to the server and do stuff anyway. If you don't trust your...
November 29, 2013 at 12:58 am
kevaburg (11/29/2013)
How could this be rewritten so it would be more secure? Ideally if I am going to implement it, I want it done properly......
This can't. To run this...
November 29, 2013 at 12:40 am
kevaburg (11/29/2013)
1. Why NVARCHAR(MAX) and not VARCHAR(MAX)? My understanding is that NVARCHAR reserves the total amount of space required to hold the variable whereby VARCHAR is more dynamic.
They're...
November 29, 2013 at 12:30 am
singh.kamaldeep (11/28/2013)
What are the criterias where this need s to run.
Straight from Books Online
DBCC UPDATEUSAGE corrects the rows, used pages, reserved pages, leaf pages and data page counts for...
November 29, 2013 at 12:23 am
Why are you running it? What made you decide to run that command?
You can cancel it, just like any other query. May sit rolling back for hours.
November 28, 2013 at 11:45 pm
It'll take as long as it takes. Probably quite a while on a large DB like that. Patience.
Why are you running UpdateUsage on a database upgraded from SQL 2008?
November 28, 2013 at 11:30 pm
ryan.costello (11/28/2013)
November 28, 2013 at 10:30 pm
External memory pressure, ie something other than SQL consuming memory? Task manager to start, perfmon with the process object later if necessary.
MemToLeave is a 32-bit concept only.
November 28, 2013 at 3:22 am
wak_no1 (11/28/2013)
November 28, 2013 at 3:20 am
Not necessarily because those pages read may be tossed out of cache fast. You can assume that a query with high physical reads is reading lots off the disk and...
November 28, 2013 at 2:00 am
Viewing 15 posts - 10,786 through 10,800 (of 49,566 total)