Viewing 15 posts - 13,276 through 13,290 (of 49,552 total)
You can look for varbinary columns. It's not a perfect indicator as other things can require varbinary (eg files), but encrypted data must go into varbinary columns.
There's no specific flags...
May 2, 2013 at 4:06 am
I would advise against any architecture or design that requires the passing of portions of queries as parameters. It's messy, it causes a hell of a lot of problems.
May 1, 2013 at 3:03 pm
Same thing. The only difference is in one you specify the PK name, in the other you get an automatically generated name. In all other aspects those two statements are...
May 1, 2013 at 2:59 pm
CREATE TABLE TelephoneDigits (
DigitID INT IDENTITY PRIMARY KEY,
Digit CHAR(1) NOT NULL UNIQUE -- todo. Check constraint to limit to 0..9, (, ) and +
);
CREATE TABLE TelephoneNumberDigits (
...
May 1, 2013 at 1:06 pm
I will ask again...
Are the files on separate drives?
May 1, 2013 at 9:55 am
Isabelle2378 (5/1/2013)
May 1, 2013 at 9:48 am
One or both of these should help
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
May 1, 2013 at 7:22 am
Isabelle2378 (4/30/2013)
Hi,I have a filegroup with one large datafile that is 300GB and I want to create 10- 30GB files and spread the data across them for better performance.
Since you're...
May 1, 2013 at 3:52 am
The table is pretty well normalised, though we don't have a candidate key, can assume that's what the identity is supposed to be. There are no repeating groups (unless there...
April 30, 2013 at 1:54 pm
ScottPletcher (4/30/2013)
According to BOL, SQL scans the table:"Rebuilding the index offline, by contrast, will force a scan of the clustered index (or heap) and so remove the inconsistency."
Yup, seen and...
April 30, 2013 at 1:46 pm
Sergiy (4/30/2013)
GilaMonster (4/30/2013)
What kinds of seats or travel options require 1000 unicode characters to explain? I'd think of seat type as 'economy', 'premium', 'business', etc, not half a novel.
Comma separated...
April 30, 2013 at 1:05 pm
And there's a target on my back. Again.
ffs, it's not as if there's some massive prize out for the 1st person who corrects me each week. :angry:
April 30, 2013 at 12:16 pm
Please post new questions in a new thread and include the full output of
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
April 30, 2013 at 12:09 pm
ScottPletcher (4/30/2013)
When rebuilding a nonclustered index offline, SQL has to fully scan the clustered index.
No it doesn't. That would be an inefficient way of running a rebuild. Both online and...
April 30, 2013 at 12:06 pm
haiao2000 (4/30/2013)
April 30, 2013 at 9:26 am
Viewing 15 posts - 13,276 through 13,290 (of 49,552 total)