Viewing 15 posts - 106 through 120 (of 280 total)
BSavoie (6/22/2012)
... I would expect them back in that order when I do an unordered select,...
Really???
Why would you expect any particular order when you do an unordered select? ...
June 22, 2012 at 10:00 pm
I just tested creating a columnstore index on an AG database and it worked fine.
You can't use columnstore indexes with replication.
June 19, 2012 at 8:00 am
yes, it is necessary.
Something I recently ran across. A table with 300 million rows (1.5 TB of archival data, on slow disks)
last auto-update of stats occurred 9 months...
June 16, 2012 at 12:51 am
rahuldhawan2007 (6/16/2012)
Thank you for the reply yes i know about the simple procedures i need some complex procedures for insert update and delete. where multiple functionality can be done.
I guess...
June 16, 2012 at 12:37 am
yes, a stored procedure can do inserts, updates, deletes and selects!!
June 16, 2012 at 12:15 am
A database doesn't have a default user.
The way to create a user is the CREATE USER command.
CREATE USER someDatabaseUser FOR LOGIN someServerLogin;
Nothing default about it.
June 16, 2012 at 12:09 am
run select * from sys.databases and save off a copy. Some settings (like being flagged as trustworthy) won't carry over.
check any non-default server configuration options (maxdop,...
June 16, 2012 at 12:01 am
If you don't have a valid FK for the date or customer or product, then why do you want it in the fact table?
June 15, 2012 at 11:46 pm
asranantha (6/15/2012)
supooste a table data contains like
...
June 15, 2012 at 11:41 pm
This is a tricky thing to accomplish.
First issue is that the application name passed from the client can be easily changed, so you can't positively identify what application is really...
June 13, 2012 at 9:09 pm
Conray (6/7/2012)
My organization has a plan to upgrade current SQL Server version from 2005 to 2012.
We will be using the same physical server for the upgrade.
At the same time,...
June 13, 2012 at 12:13 pm
DBA_SQL (6/13/2012)
We have a scenario, where Test users can get RWX access onto applications, but the same Test users should get only...
June 13, 2012 at 11:30 am
Without the query plan its hard to give firm advice.
I would definately try reducing the rows going into the merge statement:
;WITH UpdatedOdsUsers as
(select * from...
May 17, 2012 at 10:41 pm
neilwalker (5/11/2012)
How do I make the below SQL script more efficient and smaller, by changing the design and merging tables. As well as horizontal and vertical petitioning.
SELECT Manuf_name, V_model,...
May 11, 2012 at 5:18 am
Viewing 15 posts - 106 through 120 (of 280 total)