Forum Replies Created
Viewing 15 posts - 1,951 through 1,965 (of 5,356 total)
-
RE: splitting a sql string
http://www.sommarskog.se/arrays-in-sql.html
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Whois lookup from stored procedure
To extend on Steve, here's a code snippet that might give you some ideas
set nocount on
declare @ip varchar(255), @cmd varchar(100)
set @cmd = 'ping ' + HOST_NAME()
create table #temptb...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: sql server
I think it is documented behaviour that SQL Server will stop when there is no more log space available. See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;307487
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Insert and Updates without Logging
No, I don't think any question here is a waste at all !!!
Sure, my site is German since I am from Germany.
As for...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Insert and Updates without Logging
No, you can't stop them from being logged. They are necessary to ensure the system's ACID properties. However, you change can your recovery model to simple, as you already did...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Using IN in a where clause from ASP .net
Read this:
http://www.sommarskog.se/arrays-in-sql.html
and this:
http://www.sommarskog.se/dynamic_sql.html
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: What will happen if I delete the MSDB?
See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;319701
http://support.microsoft.com/default.aspx?scid=kb;en-us;198572
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Any Issues with over allocation of space?
No, none that I'm aware of.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: how to insert from Stored Procedures to #temp table
Could you give an example?
I'm not sure what exactly you want to do.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: NOCACHE equivalent ?
AFAIK has nocache something to do with generating sequences. So my best bet would be, there is no direct equivalent. However, something like the IDENTITY function might prove useful at...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Get Column Value
Glad I could help
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Data type mismatch between ACCESS and SQL server
A code snippet would be of some help.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Identity property
AFAIK, no!
You might want to try this in EM:
Create a new table. Save it. Change a column to have the IDENTITY property defined on it. Click on Generate Change script....
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Functions vs. Store Procedures
Okay, if it's for an interview, I would say the difference is that you should avoid UDF's whereever you can, while you should use stored procedures whereever you can. Exceptions...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
RE: Index on Identity Columns
If you can,you might want to read "Inside SQL Server 2000" on that topic. Might be a more reliable reference than the ones you've quoted.
While it is true that almost...
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 15 posts - 1,951 through 1,965 (of 5,356 total)