Viewing 15 posts - 7,891 through 7,905 (of 11,676 total)
ssaleh.k (2/19/2012)
Sorry the command doesn't work....Thank you
It doesn't work because you have to complete the command with the DMV you are interested in. Read the link that WRACK provided you.
February 19, 2012 at 11:55 pm
pietlinden (2/19/2012)
February 19, 2012 at 11:50 pm
The Increase Available Memory option is listed explicitly in the documentation, as other have already mentioned. Nowhere is something said about the constraint option and if it was a correct...
February 19, 2012 at 11:48 pm
What was the code that you used?
I don't remember the exact code, but you can create a DirectoryInfo, and issue the method GetFiles (if I remember correctly). This method accepts...
February 17, 2012 at 2:18 pm
Please read the articles about asking questions in my signature.
Order number can't be the primary key, as the column doesn't contain only unique values.
February 17, 2012 at 4:55 am
handkot (2/17/2012)
offtopThe performant alternative:
Create a Tally or Numbers Table
create table dbo.Tally(i int identity(1,1))go
insert into dbo.Tally DEFAULT VALUES
go 1000000
You're still performing a loop, aka RBAR (row by agonazing row).
The Tally Table...
February 17, 2012 at 2:08 am
handkot (2/17/2012)
I have a table containg a large number
DECLARE @int INT;SET @int = 1;
WHILE @int <=1000
BEGIN
INSERT INTO TestTable (id, col)
VALUES (@int, 'name' + CAST(@int AS VARCHAR(100)));
SET @int += 1;
The performant...
February 17, 2012 at 1:48 am
Joy Smith San (2/17/2012)
This is quite emberassing... Everything is is fine.. gets deployed... gets processed... sucessfully. When opening Browser it's just "loading.........".
I see a query being...
February 17, 2012 at 12:54 am
Try this:
DECLARE @myDate DATE = '2008-09-17'
SELECT REPLACE(CONVERT(CHAR(8),@myDate,10),'-','')
Be careful, as you're introducing the Y2K bug all over again 🙂
February 16, 2012 at 11:54 pm
Could you give some sample data and desired output?
February 16, 2012 at 11:49 pm
Either the object doesn't exist, or the SQL Server Agent account doesn't have GRANT permission.
February 16, 2012 at 11:46 pm
Please do not crosspost. It wastes people's time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1253582-147-1.aspx
February 16, 2012 at 11:44 pm
You could use a script task. In .NET, you have the FileInfo class that allows you to check the properties of a file. Just look for the most recent one.
February 16, 2012 at 11:25 pm
Maybe you'll get more luck with the support team of CozyRoc themselves?
February 16, 2012 at 11:23 pm
In the derived column, what expression did you use?
When you convert a column in the data conversion component, it doesn't convert the actual column, but creates a copy that contains...
February 16, 2012 at 11:23 pm
Viewing 15 posts - 7,891 through 7,905 (of 11,676 total)