Viewing 15 posts - 1,471 through 1,485 (of 2,008 total)
To me this is like saying that everything about a car is an attribute of the car, so the car table can be a flat 800 fields. I know it's...
November 18, 2011 at 12:44 am
technologies that surround SQL Server
I am novice than you. Can you give me an example?
November 18, 2011 at 12:28 am
alban_ml (11/17/2011)
yes the sql authentication is activatet and the code is correct ...can i change the code ??
Don't do anything until you are sure what you should do? Check the...
November 18, 2011 at 12:18 am
2 SQL Servers - SQL01 and SQL02 (multiple instances per server - about 60 instances total)
1 SQL Mirror - SQLM01 (houses all mirroring for primary SQL Servers)
2 Servers, 60 Instances,...
November 18, 2011 at 12:08 am
Should I suggest you some reading?
Defining Alerts
November 17, 2011 at 11:52 pm
If it's OLTP transaction table, I would recommend 85 - 90% fill factor. There should be some air to breath in, when some rows move (DML operations).
For OLAP, it should...
November 17, 2011 at 11:47 pm
The key part here being the "equality". Since (as far as I know) NULLs are considered NON Equality this would explain why the index is not being picked up.
Bingo! You...
November 17, 2011 at 11:22 pm
Are you using Distributed Transaction / Linked Server?
November 17, 2011 at 11:46 am
Try to match up your DDL with this.
Example:
CREATE TABLE TableWithSparseColumns (
DocID INT IDENTITY, DocName VARCHAR (100), DocType INT,
c0004 INT SPARSE NULL, c0005 INT...
November 17, 2011 at 11:36 am
gcresse (11/17/2011)
Thanks for the reply, Dev. I'm not sure which rule I'm breaking. Can you identify it?
First Rule... A sparse column must be nullable.
November 17, 2011 at 11:22 am
Restrictions for Using Sparse Columns
________________________________________
Sparse columns can be of any SQL Server data type and behave like any other column with the following restrictions:
•A sparse column must be nullable and...
November 17, 2011 at 11:09 am
This thread is pretty old. If you are facing some issues, I would suggest you to start a new one.
November 17, 2011 at 11:03 am
From design perspective, I can always argue that I don't need Ins_Date column. Lowest of the Mod_Date should be the same. I understand there are scenarios where it won't be...
November 17, 2011 at 10:43 am
Assuming nobody turns of identity_insert and changes data... How can you say that a row with a lower identity was NOT inserted before a row with a higher identity? What...
November 17, 2011 at 10:28 am
mak101 (11/17/2011)
SELECT * from Client Join @tblClientIds ON @tblClientIds.Id = Client.ClientId
It looks OK... What error did you get?
November 17, 2011 at 10:17 am
Viewing 15 posts - 1,471 through 1,485 (of 2,008 total)