Viewing 15 posts - 4,321 through 4,335 (of 8,753 total)
To get the information on the XML Schema collections use the sys.xml_schema_collections view and the xml_schema_namespace function
😎
SELECT
SXSC.name
FROM sys.xml_schema_collections SXSC;
SELECT xml_schema_namespace(N'[RELATIONAL SCHEMA]',N'[XML SCHEMA...
October 29, 2015 at 2:02 am
Admingod (10/28/2015)
October 28, 2015 at 5:37 pm
Admingod (10/28/2015)
Does there a way or script to find the rows, space used by the specific tables based on every year.Thanks
No, you have to monitor/audit it yourself. Normally I use...
October 28, 2015 at 5:04 pm
Angelindiego (10/28/2015)
I ended up using INFORMATON_SCHEMA.COLUMNS. I needed what info I gleaned from that view. Thank you so much for responding!!!
Quick question, Luis's suggestion points to the same...
October 28, 2015 at 4:59 pm
Ed Wagner (10/28/2015)
Eirikur Eiriksson (10/28/2015)
Ed Wagner (10/28/2015)
allnelsons (10/28/2015)
October 28, 2015 at 4:53 pm
Jeff Moden (10/28/2015)
Eirikur Eiriksson (10/28/2015)
Ed Wagner (10/28/2015)
Eirikur Eiriksson (10/28/2015)
happygeek (10/28/2015)
nibbleQuark
String
Tension
"Wait-till-last-minute"
(83-code-reviews-in-2-days-on-urgent-project :sick::blink::unsure:)
Ultimate tensile strength (UTS)
October 28, 2015 at 4:05 pm
Ed Wagner (10/28/2015)
Eirikur Eiriksson (10/28/2015)
happygeek (10/28/2015)
nibbleQuark
String
Tension
October 28, 2015 at 3:48 pm
happygeek (10/28/2015)
Ed Wagner (10/28/2015)
crookj (10/28/2015)
Revenant (10/28/2015)
DonlSimpson (10/28/2015)
Ed Wagner (10/28/2015)
anthony.green (10/28/2015)
Ed Wagner (10/28/2015)
whereisSQL? (10/28/2015)
anthony.green (10/28/2015)
whereisSQL? (10/28/2015)
crookj (10/28/2015)
anthony.green (10/28/2015)
Ed Wagner (10/28/2015)
anthony.green (10/28/2015)
Ed Wagner (10/28/2015)
anthony.green (10/28/2015)
Ed Wagner (10/28/2015)
SushiWasabi
Soy
Bean
Navy
Sailor
Pirate
Eye-Patch
Arrrrrrrrrrr
Treasure
Loot
Classifieds
Ad
Subtract
Number
1024
Byte
nibble
Quark
October 28, 2015 at 2:08 pm
At least some people have proper manners
😎
October 28, 2015 at 12:25 pm
ChrisM@Work (10/28/2015)
Koen Verbeeck (10/27/2015)
...Happy birthday geezer. It's beer O'clock 🙂
Proost
😎
October 28, 2015 at 12:19 pm
Ed Wagner (10/28/2015)
allnelsons (10/28/2015)
October 28, 2015 at 10:35 am
Quick question, have you tried starting the SQL Server in single-user mode?
😎
October 27, 2015 at 11:19 am
Koen Verbeeck (10/27/2015)
How did you create the delta?
Using the EXCEPT operator? This might be quite slow on the larger tables (about 10...
October 27, 2015 at 4:30 am
ChrisM@Work (10/27/2015)
anthony.green (10/27/2015)
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver spoons on...
October 27, 2015 at 3:58 am
Did something similar a while back (in the age of the slow Internet) by adding in a step in the restore process. An "untouchable" originating database (SQL mirror of an...
October 27, 2015 at 3:51 am
Viewing 15 posts - 4,321 through 4,335 (of 8,753 total)