Viewing 15 posts - 1,891 through 1,905 (of 2,007 total)
I want to convert the given table into following table without using any other intermediate table:
0 39285
0 56579
0 58244
0 60227
0 7433 7434 7435 7436 7437
0...
October 15, 2011 at 1:32 am
cdumont (10/14/2011)
The Maintenance job...
October 15, 2011 at 1:24 am
I am trying to free unallocated space on tempdb.
May I know why do you want to do that? If you have any issues, following article might help you.
Troubleshooting Insufficient...
October 15, 2011 at 12:53 am
farax_x (10/14/2011)
any one here !
Have patience. Professionals here on SQL Central manage to find some time from their busy schedule to share knowledge. It’s not a Customer Support portal where...
October 15, 2011 at 12:34 am
shanesmith142 (10/14/2011)
hgfhgd
Reporting SPAM!
October 14, 2011 at 7:47 am
Device CAL not User CAL
My bad... time for another cup of coffee :doze:
October 14, 2011 at 6:47 am
if you had one machine in your office that had the sql tools and people shared the machine you could be okay.
The snippet below is from 2008 SQL...
October 14, 2011 at 6:40 am
CREATE PARTITION FUNCTION InventoryFinishedGoods (char(3))
AS RANGE LEFT FOR VALUES ('DFG', 'MFG', 'AFG');
Just a thought (may be outside OP’s requirements).
However Partitioning supports multiple data types but I assume it performs...
October 14, 2011 at 6:23 am
That way you pay nothing in extra license fees, but you can possibly pack anoter 1000 users on there.
I didn't get quoted statement. Would you elaborate it please?
October 14, 2011 at 6:14 am
So you can't just make a single login, give it to 3 or 100 persons and just buy 1 cal.
Many organizations follow such practices. They create 1 login...
October 14, 2011 at 6:07 am
andy.l (10/14/2011)
I hope someone could provide me some feedback on this issue.
On day to day basis I (the DBA) interact with our in house development team regarding our web platform....
October 14, 2011 at 5:59 am
that will search through the whole database for a particular name in the data
Can you please rephrase your questions?
When you say data, does it mean table / view / column...
October 14, 2011 at 3:46 am
The day goes by :
get up
go to work
Get back home (hopefully the same day).
Not everyday... Only on QA deployment, Staging Deployment & Production Deployments. And yes on BUG...
October 14, 2011 at 3:39 am
How does everyone else manage their time? What do your schedules look like? I realize every environment is different, but I'm curious and wondering if I'm crazy.
I have a doubt...
October 14, 2011 at 3:31 am
My users want a copy of a remote database saved onto a local server and kept in read only mode. Once a week they'd like it updated with any...
October 14, 2011 at 3:16 am
Viewing 15 posts - 1,891 through 1,905 (of 2,007 total)