Viewing 15 posts - 871 through 885 (of 3,011 total)
barry.a.seymour (5/4/2011)
...
I tried writing a stored procedure that uses BULK INSERT but xp_cmdshell is turned off on the server so that option's out as well
...
BULK INSERT is an SQL command,...
May 4, 2011 at 3:32 pm
I suggest that you work on your written English communication skills.
May 3, 2011 at 3:52 pm
Raymond van Laake (5/3/2011)
I would appreciate any feedback on my backup strategy. I also have a question or three. Note that there is little or no activity between 22:00 and...
May 3, 2011 at 3:49 pm
sqlbuddy123 (5/1/2011)
But in real world, with this approach the management becomes complex if you have large...
May 3, 2011 at 2:50 pm
Another option is to use Sharepoint to store the documents in a Sharepoint database via an application.
We have a system with more than 600,000 PDF files stored in Sharepoint (SQL...
May 3, 2011 at 2:16 pm
Just tell people you're a cowboy. No one ever asks for help branding their calves.
April 29, 2011 at 10:53 am
Tables and indexes are stored in filegroups not in files, so a table will usually be distributed across all files in a filegroup.
April 29, 2011 at 9:20 am
You should use one service account per server.
If you share service accounts, then someone with sysadmin access to one server can gain access to all the other servers.
If you share...
April 28, 2011 at 3:11 pm
I would still be inclined to assign the RAM to SQL Server before using it for tempdb and let tempdb stay on physical disk, unless SQL Server is generating no...
April 28, 2011 at 7:49 am
Daniel Bowlin (4/27/2011)
April 27, 2011 at 9:22 am
That is exactly what SQL Server is designed to do.
By using as much memory as possible, SQL Server is able to hold more data pages in cache and doesn't have...
April 27, 2011 at 9:10 am
Use a CHECK constraint.
April 27, 2011 at 8:46 am
You can use them on most major airlines for free upgrades to DBA class.
Just ask at the ticket counter when you check in.
April 27, 2011 at 8:29 am
parthi-1705 (4/27/2011)
TrySelect 'EN'+CONVERT(varchar,DATEPART(yy,getdate()))+
CONVERT(varchar,datepart(mm,getdate())) +
CONVERT(varchar,datepart(dd,getdate()))+
CONVERT(varchar,datepart(HH,getdate()))+
CONVERT(varchar,datepart(MI,getdate()))+
CONVERT(varchar,datepart(SS,getdate()))+
CONVERT(varchar,datepart(MS,getdate()))
this will never repeat unless you change server time.
I'm not sure why you posted that on a 3 year old topic. :unsure:
In any case, that will...
April 27, 2011 at 7:22 am
A situation I have run into a is old software that is no longer supported by the vendor or the vendor is out of business. Getting old software to...
April 27, 2011 at 7:16 am
Viewing 15 posts - 871 through 885 (of 3,011 total)