Forum Replies Created
Viewing 15 posts - 34,411 through 34,425 (of 49,552 total)
-
RE: Update a filed in the group
Biz (1/26/2010)
Thank you for your reply.Thats giving me the real data i want.
But
When I tried all values for Rank as false, its giving me NULL as value.
How can...
-
RE: DBCC shrinkfile()
Sourav-657741 (1/25/2010)
-- Is it suggestible to opt for datafile shrink since it gives birth to fragmentation.No.
Shrinking causes massive fragmentation and will just result in the data file growing again next...
-
RE: [Help] Optimize report query
I'm not sure if you want help writing a query or optimising an existing one.
If you want help writing a query, please post table definitions, sample data and desired output....
-
RE: Looking the best way to storing NOT NULL in table
miss.delinda (1/25/2010)
My reason to make it Remarks is Not Null because it'll allow me to index this columnif me make it this Remarks allow Null, this column can't be indexing
Create... -
RE: understand following concepts of resouce database:
andrewkane17 (1/25/2010)
isn't this a point of failure that cannot be easily be remedied whenever the mssqlsystemresource.mdf and mssqlsystemresource.ldf ever become corrupt?Yes, but since those only change when service packs/hotfixes...
-
RE: sql server 2005 query
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
-
RE: Are the posted questions getting worse?
Think I've found the crystal ball... Doesn't seem to be showing much though.
-
RE: Db level trigger
You can't actually do that.
DML triggers, the type that fire after data changes, are per-table and have to be created on a table.
The database-level triggers are DDL triggers, they fire...
-
RE: Looking the best way to storing NOT NULL in table
My honest opinion...
If a column is optional and it's valid and allowed for there not to be an entry in that column, make it nullable and let null stand for...
-
RE: alloc_unit,type question
gmamata7 (1/25/2010)
So here, the bold text lines, even if the index type is clustered & non clustered, the alloc unit showing as IN_ROW_DATACorrect
because it show IN_ROW_DATA for only heap right?...
-
RE: can synchronous mirroring cause long running transactions?
The principal should detect that the mirror's not accessible and go into the disconnected state. Should.
-
RE: can synchronous mirroring cause long running transactions?
winston Smith (1/25/2010)
If i get a network issue between my mirror and primary, and am using synchronous mirroring, is this a sure way of getting long running transactions.Maybe. Depends whether...
-
RE: rebuilding Indexes Online?
You can't. Indexes that contain XML or the MAX datatypes must be rebuilt offline. That includes the clustered index of a table that has one of those columns in it.
You...
-
RE: A dumb question about Distinct - I posted this in the wrong forum earlier by mistake
The_SQL_DBA (1/25/2010)
Gail, I think I missed it completely. I removed the distinct from the second query now..Nope. You've fixed one out of 3.
Why have you left the brackets around the...
-
RE: Urgent development question
Greg Edwards-268690 (1/25/2010)
Just a thought...If this is development, you may want to review the design.
Absolutely. Comma-delimited lists in a column are a violation of 1st Normal Form and are...
Viewing 15 posts - 34,411 through 34,425 (of 49,552 total)