Viewing 15 posts - 9,736 through 9,750 (of 49,571 total)
I'm feeling like a parrot today.
"Let me repeat what has already been said in this thread"
"Let me repeat what I said earlier in this thread"
"Let me quote the answer to...
March 11, 2014 at 5:36 am
Sure.
You ensure that every single piece of code that could ever possibly update the deleteflag of tablA also goes and updates the deleteflag of the other tables.
March 11, 2014 at 5:32 am
yuvipoy (3/11/2014)
GUIDs certainly can be used as clustered indexes, nothing prevents that.
why not if it is not alpha numeric?
Don't understand...
March 11, 2014 at 5:18 am
March 11, 2014 at 5:09 am
GUID ordering is not alphanumeric. There's articles on the web which describe how GUIDs are ordered, not that it usually matters much for users.
March 11, 2014 at 4:23 am
Um....
GilaMonster (3/11/2014)
The publisher is the database you're working with.
i.e. the one you're trying to change the primary keys in. So you've already found it.
March 11, 2014 at 4:01 am
Do you have a performance problem at the moment?
If not, then design your database according to good data design principals (including picking the correct data type for the expected...
March 11, 2014 at 3:54 am
praneethydba (3/11/2014)
Client is asking to reduce the memory utilisation for DB server...
Tell the client that
SQL Server will take all of the memory - up to the max memory setting -...
March 11, 2014 at 3:53 am
Again, why is that a concern?
From earlier in this thread:
SQL Server will take all of the memory - up to the max memory setting - that it needs. If you...
March 11, 2014 at 3:24 am
Silverfox (3/11/2014)
however doesnt using tablock, switch to using tempdb for the work that is carried out.
No. It switches to using table locks for stability rather than a database snapshot.
But i...
March 11, 2014 at 3:21 am
praneethydba (3/11/2014)
Now the memory Utilisation is 70%...what to do?
Nothing?
Why do you feel that something needs to be done? What problem are you trying to solve here? What is the...
March 11, 2014 at 2:42 am
The publisher is the database you're working with. As for changing the replication, go speak with the DBA/developer who set the replication up.
March 11, 2014 at 2:40 am
Are you editing out the filenames in those messages, or is SQL really reporting extensions without names?
Operating system error 1450: http://blogs.msdn.com/b/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx, so you may not be able to use a...
March 11, 2014 at 2:28 am
Consumes more space than what?
If you want a list of the tables and their sizes, have a look at the sys.dm_db_partition_stats DMV.
March 10, 2014 at 10:10 am
Viewing 15 posts - 9,736 through 9,750 (of 49,571 total)